HI All

I am setting up a spreadsheet, where i have separate sheets for each Month and a summary sheet, where I want to pull in specific data from each of the month sheets. 

I want specific cells in the summery sheet to reference specficic cells in the ‘month’ sheets. 

For each month in the summery sheet, i want to reference about 10 different cells in the month sheets. 
At the moment i am doing this with the simple formula =’24 April’!D2. etc. 

However, every time i add a month sheet, and therefore row in the summery sheet, i have to ammend the reference in each of the 10 cells. 

Is there a way that i can make this more efficient, i.e. only changing the ’24 April’ reference in one place rather than 10?

I hope that makes sense, any help would be greatly appreciated. 

​HI All I am setting up a spreadsheet, where i have separate sheets for each Month and a summary sheet, where I want to pull in specific data from each of the month sheets.  I want specific cells in the summery sheet to reference specficic cells in the ‘month’ sheets.  For each month in the summery sheet, i want to reference about 10 different cells in the month sheets. At the moment i am doing this with the simple formula =’24 April’!D2. etc.  However, every time i add a month sheet, and therefore row in the summery sheet, i have to ammend the reference in each of the 10 cells.  Is there a way that i can make this more efficient, i.e. only changing the ’24 April’ reference in one place rather than 10? I hope that makes sense, any help would be greatly appreciated.      Read More

​