VBA to generate # rows based on cell value and insert information

Hi and thank your for any help/guidance provided!

My workbook is attached. My goal is to drop in the report on the Acrotime Report tab and have it autogenerate my data. I have my data setup, I am just stuck on the VBA portion.

The tab Master List has the # of rows in column E. These rows should be entered on the Import File tab. The first employee was completed manually as an example.

Each row corresponds to a location ID and number of hours per earning code. This information is found on the tab Acrotime Report.

Regular hours are submitted to the location noted in Column F on the Acrotime Report tab (column E on the Import File tab). Columns H, I and J are totaled for each employee and spread between their locations worked based on the locations hours ratio. So if location 1040 has 50% of an employees hours, it will receive 50% of their PTO hours as well.

All of this information then makes up the Import File sheet, one row per employee, per earning code, per location.

I imagine I want to loop through the list on Master List, I just don't know how to transfer the data via VBA from Acrotime Report to the Import File in the propert format.