Combing two codes

So I have my first code that allows me to choose what folder to open and it auto selects what file to open to copy and paste from, but the range is not right.

My second code allows me to select what folder to open and I have to choose what file to open and it copys and pastes based on column header.

What I want to do is integrate my second code into my first code. Put the copy and paste based on column header into the first code.

First code:

Please Login or Register  to view this content.

Second code:

Please Login or Register  to view this content.

Do you have a question?