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!