I have a spreadsheet with multiple tabs (about 30). I want to pull and make a table or condense into a column on one tab. The cell will always be the same, lets say A1.
How can I do this with code, regardless what the tab names are?
How can I do this with code, regardless what the tab names are?