We learnt earlier how to transfer one row of data from multiple workbooks to a master workbook using VBA. In thie video we learn how to transfer large amounts of data from multiple workbooks to a master workbook, how to access different files and turn off the Clipboard warning message using VBA. For details you can visit:
http://www.exceltrainingvideos.com/how-to-transfer-multiple-rows-of-data-from-multiple-workbooks-into-master-workbook-with-vba/
For more knowledge read the book Excel 2016 Power Programming with VBA: http://amzn.to/2kDP35V
If you are from India you can get this book here: http://amzn.to/2jzJGqU