View Single Post
  #1   Report Post  
Steve
 
Posts: n/a
Default Copying the same cell from different sheets

I have a bunch of worksheets, each formatted identically. Let's say their
names are "A" to "Z". I insert a new sheet and I want to examine the same
cell from all sheets. Suppose there is a value representing annual expenses
in cell D13 of each sheet. My new sheet might look something like this:

Sheet Annual Expense
A $100
B $150
C $200
etc.

Is there a way to do this without having to enter the formula separately
into each cell? It seems to me I saw somewhere a way to "build" a formula by
stringing the components together.