getting cell values from multible sheets

B

bwcalvin

I have 100+ sheets in a workbook that I want to get a cell value (or
defined cell name) from each sheet and place them in one sheet. So, i
there was a cell named count1 for sheet one and count2 for sheet2 etc
I need to collect those names and place them on one sheet
 
G

Gilles Desjardins

Insert, Name, Paste, Paste list should do the trick.

Hope I understood your question properly.

Gilles
 
Top