Good afternoon,
I'm not sure if this can be solved by formula or macro, but any help would be appreciated. Basically what I am trying to do is pull data from cell c3 from multiple sheets into the master sheet. Please see attached for reference. I have over 100 sheets that I need to pull data that information from and was wondering if there's a easier way than manual. I tried the =indirect formula, but that still requires to put the information manually. Please let me know if clarification is needed.
Thank you,
Sample.xls
Bookmarks