You really need to tell us a litte more detail.

"Laird" wrote:

I have about 30 profit and losses for different departments of a
company. Each P&L shows data for many years. I would like to have
one summary spreadsheet which has only the sales and EBITDA
information for each P&L worksheet but I don't want to have to link
each cell individually since, for example, each Sales amount for 2002
is in cell C23 of each worksheet. Is there a way to do this more
efficiently?

Thank you!