create a master list from other sheets
 

I have 12 sheets that consist of bill of materials. I would like to have a
master sheet which combines all the sheets into one bill of material.

Problem: Sheets can vary the number rows of data.

Need: Is there a way to have excel will take a range of cells where it would
know the last row of data.

Done:
Column A is labeled ID. This column contains a row number if the row has
been populated (this part I have done successfully).

Thanks for any help.