Hi Good Day!

Could someone helps me to collates all the data from many sheets to a single master sheet. In my case, i have 85 sheets of data and need to merge in order base on their sheet no. to master sheet (a.k.a "Model Engine").

To solve:
  1. Copy data from sheet: F6 to Model Engine (cell D); F8 to Model Engine (cell E) and F19 to Model Engine (Cell E below data from F8) (pls refer to comment on my sheet)
  2. The data from sheets (D25:S) need to be copied to Model Engine (F5:U)
Hope you guys can understand what I mean. Your time and effort are highly appreciated.

Sample.zip

Thank you very much.

Halimi T.