I am trying to link data from cells in a particular sheet to cells in another. I have on sheet that has tabs for each day of the month. I have another sheet that pulls certain cells from these tabs to a summary layout of each day. Is there a way to use a cell in the summary sheet to determin the TAB to use from the linked sheet. This is the linked cell =-(‘file:///Volumes/To_Sort/Docs/Cash Drawer Sheets/2020/08-2020-Aug.xlsx’#$Aug1.B$14) the 08-2020-Aug.xlsx sheet has 31 tabs. I want to have cells in the new sheet reflect the Aug1.B$14 cell then the next cell reflect Aug2.B$14 and so on. How can I incramentally adjust the TAB title?
Sure. Just use INDIRECT around your external reference, then concatenate what you need to build up that reference.
IndirectReference.ods (9.5 KB)
I won’t bother to load up a source ODS for this…it’s pretty straightforward once you see it.