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.