I have several sheets that includes information on several parts that were
measured and I would like to create a summary sheet that aranges the data
from the part sheets and into the summary sheet while putting them into a
column, there I can do some analysis on them. I can hand type each cell to
look at a specific cell within the sheets but when there are over 100 sheets
it can be a very long process.

What would be the best way to arrange this data?