Make a new Format with VBA based on the data

Hello,


I have a problem work with two different type of workbook, it is a bit time consuming if I do it with a manual typing or copy pasting.
Is the any Solution to copy data to a certain format with vba code.

Note:
the first format if Feedmaster## and the 2nd is the target (or copy to new worksheet in Feedmaster##)

Your end result is hard to understand, the numbers do not match the source sheet.