Consolidating Worksheets issue

Im having two issues

Issue 1) at the top of my "IMPORT" sheet its duplicating the header name in A1 so that it is appearing twice once in cell A1 where it should be and in A2.
Issue 2) I want to change this to actually pastes values into the "Import"

Here is my code

Please Login or Register  to view this content.

Originally Posted by Glervey

Issue 1) at the top of my "IMPORT" sheet its duplicating the header name in A1 so that it is appearing twice once in cell A1 where it should be and in A2.

more than likely that's because the code needs to be modified. see image 1 below for where the issue is at, and image 2 below for what results from it: