I have 10 excel files that have a standardized data entry. I want to link the
data together in one file and have the data automaticaly update itself in
that consolidated file while other people do data entry.

Is this possible???