Copying from multiple wkshts into one wrksht using a loop for endof row for each wkst

[katkins0429]

Hi I am wondering if someone could help me with a soloution. I have a workbook that has specific data feeding from various other workbook (using linked formulas). Within this workbook (my master workbook) I need to create a copy of all the worksheets (not the menue sheet or the cmd sheet) into one master sheet. However since each worksheet has a formula I cannot use a vba to find the end of the sheet, however I could use application count if row does not equal "", to count to the end of each row.

I have attached a test workbook for your review. I am not sure if I am explaining my issue correctly.

Thank you