Merge Multiple Workbooks into One

[jo15765]

I have a directory with roughly 65 workbooks in it. I need to take the data from each worksheet and add them all to one Worksheet in a new workbook, and append the workbook name to column A.

Using Excel 2013 how would this be achieved?

[Bob Phillips]

Power Query.

[jo15765]

Power Query.

Sample syntax?

[Bob Phillips]

Google it, there are tons of examples out there.