use a cell containing the name of a sheet as a sheet name in ...

B

Bill Nielsen

I am collating data from several sheets into one sheet in a workbook. All
the sheets have the same data structure. I would like to put the sheet names
in cells on the top sheet then reference this cell to build formula's to
bring the data from the lower sheets up. This way I can make the formula
with drag rather than hand entering them or editing them.
 
Top