marco button to update master sheet from multiple workbooks

Hey Guys,

I have a big one here and need some macro help i believe. What i am looking for is code for a button i can put on a master sheet that will update information from multiple workbooks.

I have a shift report at work for each day of the month and inside that shift report we have a tab that says sign ups. in the sign ups tab we have people who we signed up and what there play was. So what i am looking for is to have 1 master sheet in the folder that when i hit the button it will populate that sheet with all the sign ups for that month.

The destination folder is this

H:\Host File\Host Shift Report\August

With in August i have multiple sheets that are August 3 2009, August 4 2009 etc. In those workbooks the tab is Sign Ups.

Here is an example of what i need. You will notice that on some of the sheets i have put dummy info in the signups tab. Thats the stuff i need to update on the master sheet.

Thanks and any help is greatly appreciated

Hi
save the attached file inside the folder containing monthly data of sign ups and run the macro
Ravi

Hi ravishankar,

Great job on the macro but it doesn't populate with any info. I really appreciate your time on this, i was kind of hoping it would populate the Total Sign ups sheet that i included. Anymore help is greatly appreciated.

Thanks again
Mikey

Hi
Give this macro a try
ravi

Still no go. When i open the workbook and update links it can't find Copy 3 of August 3 2009. If i try it regardless still nothing populates. Thanks again for your time with this.

I appreciate it

Mikey

*********bump**********