Transfer data from multiple worksheets on excel

Occasional Visitor

I have several worksheets that were originally organized into rows. They all contain the same elements in the same location, ie "age" is in cell B7 in all the sheets. I am trying to organize and analyze the data and want to move different elements into a separate worksheet. For example, I want a "age" column that pulls all the B7 cells from the other worksheets. And another one for height, weight, etc. Having trouble finding a way to transfer the data in an organized and time-saving fashion. Thank you

1 Reply


You can easily solve this with the INDIRECT() function. You only need a list of table names and then you can assemble the cell reference with INDIRECT(). See the attached example document.