Pulling data from 3 different files into a master file

Hi, So I am trying to pull data from 3 different files into one master file. All the 3 files have the same amount of columns but the rows keep increasing or decreasing.
I am also trying to stack the data one below another. So I pull all the columns from Book1 which includes the headers too, after that headers are not needed so I delete the headers from the other 2 files while doing so..

I have successfully pulled data from Book1, but I have gotten stuck on Book2 hence can't finish the process..
Here is the code so far..

Please Login or Register  to view this content.

Put the files in a single folder and then try this (change myPath to suit):

Please Login or Register  to view this content.