I have a file that contains 80+ worksheets and I need to the pull the data from cell A2 of each worksheet and create a list of the contents of each of those cells in another worksheet. Besides manually entering ='sheet1'!A2 or similar, is there a way to do this without having to complete a formula for each sheet?
thanks!
Bookmarks