excel training class - Look-up Tables

Hi Amanda,

What I was trying to do was consolidate several spreadsheets into one. We are doing forecasts and there are 4 account handlers forecasting their results for the year and what I am trying to do is consolidate the results so that we can view the results of the whole team by looking at one sheet that I am trying to create.
I tried simply linking the cells in the 4 individual sheets which are in 4 different locations and it worked until a change was made and I am not sure how the links should be updated or whether this is not possible, but the consolidated spreadsheet was not updating.
Im not sure whether look up tables would work here or something else.
Might you be able to help?
Here's hoping! Many thanks, Philippa