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