Hi All,

I was wondering if you could help me. I'm looking for a macro to help me combine several workbooks (each with 4 worksheets) into one Master sheet.

Here's a little background:
- Each workbook is operated by a different member of staff
- The different tabs represent the different statuses of various bookings (Closed, Confirmed, Pending and Cancelled). The data contained on all of this is in the same format
- I would like to import all of the data to a common worksheet.
- The master will need to be updated daily, as staff will be working on thier personal workbooks and making changes a few times a day.

I have seen a few codes, but I am just beggining to learn about macros so all explanations are appreciated

I hope you will be able to help!

Thanks,
Alex