Copy multiple files via vba code

[hshone]

Hi all,

im looking to copy multiple files into one file.

In column a:b I have date and unique file path starting at row 5 respectively.
the excel files I want to open the data starts at a5 and what to copy all data across and down from this point.

I would then like to paste this data into the main workbook with column "a" having the date for the data into say "sheet 2" Then open the next file copying data at the next available row.

So so it will ideally look like the below.

1/1/15 data data data
1/1/15 data data data
1/1/15 data data data
2/1/15 data data data

and so on.