Merging Excel Documents

[mcordani]

Hi Everyone,
I am some what skilled in excel but am having trouble.

I supervise about 270 people, and have them separated by department with names, emails etc.

Is there a way to link the documents from separate workbooks with separate sheets into one sheet on a separate work book, like a master staff list.

Some are trained in multiple departments, so I would like to change their info in one spot and have it update in each department sheet, and vice versa,

I have been playing with consolidate and links etc, just having trouble.

Thoughts?



Michael