Need Excel VBA help.

I have a workbook with 2 sheets. The 1st sheet is where to place the copied data from another workbook and the 2nd sheet is where to automatically place the data from sheet 1 without duplicates.

Details:
The workbook to copy has multiple sheets and only 1 sheet will be copied. Only column B to F and column J to N.

The destination workbook has 2 sheets. The copied column B to F and J to N will be pasted starting from column “A” on sheet 1. Sheet 2 will be automatically filled with data coming from sheet 1 starting at column “A” minus the duplicates. Duplicates will be determined by column “A”, Column “G to I” and then Sorted by column “A” and “G”. In this sheet the VBA code will be written.

Process:
Open workbook with the VBA code, then run the code to import the data (from another workbook) to be stored on sheet 1 and automatically populate sheet 2 without the duplicate and sorted out.

I hope that you can help me with this VBA problem.

Thank you in advance.