My wife took on a treasurers fob for a small non-profit, previously the books have been on paper and I am trying to setup up a Drive spreadsheet to help make reporting easier. I have the first sheet as a report sheet and sheets 2-13 as monthly ledger. I would like to have cell b6 on sheet one as a reference for the sheet of the monthly report, instead of changing each cell manually every month. When I use =b6!i50 I get an error, unresolved sheet name. If I use =January!i50 I get the correct number, how do I assign b6 as the sheet name, so we just type in the month of the report and all cells change.
