Copy Data from several Workbooks to Another Workbook

[Trolldi]

BTW. what version of excel are you using, and are all these workbooks to be found in a particular folder?

Hello, I am using office 2016, latest update. but I hope during this year we change it to Office 365. Workbooks will be in same folder, path I know how to change.