Multiple workbooks feeding one master workbook

I work for a manufacturing company who produces parts for many clients. We have three separate workbooks for our three major clients that contain all of their in-process orders.

I'm wondering if there's a way to use formulas to copy info from these three separate workbooks (they have identical columns) and have them fill the "next blank row" when they are pulled in.

Basically, the sales team members wants to be able to pull up and manipulate their own excel workbooks (each member has one of the top three), but our contract administrator wants to be able to open up one document and view all the current open orders, allowing her to asses priority of parts hitting the floor, being shipped, etc.

If this can't be done with formulas and requires VBA work, that's fine. The simpler the better, though. A lot of the people who will be using these are not extremely excel literate.

Thanks for the reply.

All of the files will be stored on our server. A hotkey to update sounds great. The less they have to fumble around with the ribbon, the better. haha

I'd like all of the data on this "parent" file to match the other "children" files exactly. This way the sales team can update their own files and do all the information tracking, and the contract administrator can just review the information, compare it, and make decisions based upon their info.

Thanks again!