Lookup External Data

[Humming Bird]

1. I have five stores. At the end of the day each stores enters stats for
the day in an excel worksheet and saves it.

2. I would like to open up a worksheet and be able to scroll down through
data that was entered on each of the five store locations. Just as the
store would have looked at it... only I could scroll down to the next
stores info.

3. I know how to do cell refrences... but how do you bring an entire sheet
into your local worksheet? Anyway to say that this area a1:z26 equals the
looked up range of cells?

Thanks for any thoughts the group may have.

 

[BrianB]

The easist way is a quick copy/paste to the bottom of the sheet