Pull data from same cell from multiple sheets into master column

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

Hi Arlu,

That macro works, is there a certain way to make it start on a certain cell? like for example if I wanted the data to start inputting on cell b6

That's works, thanks!

Not sure if I should start another thread, but what if I wanted to exclude certain sheets, would that be possible?

Good morning...

If I wanted to let's say exclude Rick Perry and Rick James...

tried the code and it still seems to be pulling the data from those pages.

Sample.xls

thank you for all your help!! everything works perfectly