I have 50 worksheets in one file. They are all formatted identically. I need to pull certain data off of every single sheet, but don't want to pull five cells manually from each sheet. THough I know I can use a simple (=) to show the data in the cells I want, since I have to do it for so many sheets I was wondering if there was an easier way.
Basically, there are five cells on each sheet that I need to show in another summary list sheet. Is there any way to automate that process?
To further try to clarify, say I need Cells A1, B3, C5, D7 and E9 (From Sheet1) to show up in my final sheet. But I want them to be in a single row (A1,A2,A3,A4,A5, respectively), because I will have 50 rows of the exact same information. Like I said, I can use a simple = to get them in, but then I would need to either do that individually for all the sheets or copy it 50 times and edit the sheet names in the reference.
Thanks in advance.
Basically, there are five cells on each sheet that I need to show in another summary list sheet. Is there any way to automate that process?
To further try to clarify, say I need Cells A1, B3, C5, D7 and E9 (From Sheet1) to show up in my final sheet. But I want them to be in a single row (A1,A2,A3,A4,A5, respectively), because I will have 50 rows of the exact same information. Like I said, I can use a simple = to get them in, but then I would need to either do that individually for all the sheets or copy it 50 times and edit the sheet names in the reference.
Thanks in advance.
