Merging and Linking Worksheets
 

I'm fairly new to Excel and I have a question that I don't know if this even
works in Excel. Currently, I have five employees working on five different
workbooks all day. They have about forty columns (each workbook has the same
columns) and the records are continually added and removed. These workbooks
NEED to stay separate files.

What I want to do is create a new workbook that would have a sheet that
combines the five sheets. It would be a separate file from the other five,
but have one spreadsheet that is the combinate of all five and updates with
their updates. Since all of the columns are the same, I figured there was a
way to do this. The most important thing is that it will take all of the
information from one worksheet in each workbook and combine them to one
worksheet in the new workbook.

To make it clearer:
Five separate workbooks (called Balocs, AFS, Leases, BILs, and COLL). They
all have the same worksheet inside (called CurrentInventory).
I want a new workbook (called Total) that will grab all the records from the
five workbooks and put them in one consolidated worksheet (called
TotalInventory). A HUGE importance is that when one of the five workbooks is
updated, the total inventory is adjusted as well to add, edit, or delete the
record.

If you need more clarification, please let me know. I'm new on the
terminology so please just bear with me.

Thanks!