One way is to use INDIRECT such as shown from one of mine looking up a
symbol from Yahoo finance where the data sheet info is wiped out with each
web fetch.
=IF(ISNUMBER(D5),VLOOKUP($A5,INDIRECT("Data!B1:X10 00"),5,FALSE),"")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MarkT" wrote in message
...
Hello all,

I am running Excel 2007. I have created a stock tracker spreadsheet that
has a number of sheets containing specific data on each individual stock.
I
would like to have a summary sheet that takes certain data from these
individual sheets and summarizes them. Data that I would like to
summarize
is name (E2), Symbol (K2), Buy (E7), Buy Date (E20), Shares (I20), Sell
(S7)
Sell Date (W7) Result Price (S26) and Result Trade (W26). These
individual
sheets are all identical and the same data is located in the above cells
on
each individual sheet.

Is there a way that once either data is entered into these cells, or a
calculation is made into one of these cells that the same info is
automatically updated on the summary page?

The number of these individual sheets will vary as stocks are bought and
sold so the number of entries on the summary page will vary by the number
of
sheets contained in the workbook.

I hope I have provided the needed information.

Thank you very much for your anticipated help in my dilemma!