Build excel Formula (VLOOKUP) to automate data entry

I have an excel file that's generated by an app on a weekly basis. I need to grab this data and put it into another excel sheet in a particular format. You will need to be familiar with VLOOKUP, and other excel functions to build this formula.

I AM **NOT** LOOKING FOR MANUAL COPY AND PASTE.

I'm looking for to build this formula so in the future, when I receive new weekly generated excel files from an app, the formula is smart enough to populate the new sheet.