Merging Workbooks with Multiple Worksheets

[kronik]

I've been searching for about an hour now and have yet to find the solution to my problem.

I have 15 workbooks, i.e. Inventory 1, Inventory 2, Inventory 3.

In each of these workbooks there are 5 sheets, Desktops, Laptops, Printers, Monitors, Hubs.

On each sheet, the categories are applicable to the inventory.

Essentially, these 15 workbooks are identical in format, with different data.

I would like to merge all of the workbooks either into one workbook with 5 sheets that has all of the data from all of the workbooks.. or an Access database with all of the data from all of the workbooks. These are workbooks on Sharepoint that are constantly changing so copy/pastespecial does not apply here. Someone help me, please.

[kronik]

Here's a sample.