Copy Pasting to a new format Using Macro

I have a problem work with two different type of workbook with the same data in it, 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 different format with vba code.

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