I have a spreadsheet that has 13 sheets, 12 named as months and the final sheet named totals.
In each month one of the cells has a total figure that i want to import into sheet 13 (total) enabling me to have twelve figures which will then allow me to get a final total of all 12 months (Sheets 1-12). I need to do this for several figures but 1 example should allow me to do the remainder.
What is the formula that i need to put in for this to happen.
Example sheet 1, cell A40 i want to automatically put that figure into sheet 13, cell A1
Any help would gratefully be appreciated
Bookmarks