Transfer Data from Multiple Workbooks into Master Workbook Automatically

We can transfer data from multiple workbooks into a master workbook automatically using Excel VBA.
Sherin has created a template file with specific headers. Her suppliers have also been instructed to have the same headers with the relevant data below them. Now when the suppliers send her the workbooks by email, Sherin transfers them to a common folder where she has her template or master file. She wishes to now automate the process of transferring the relevant data from the suppliers files to her master file.
The process involves the following VBA code:
(1) Find out how many suppliers files are there in the folder
(2) Open the files one by one
(3) Copy the relevant data
(4) Close the suppliers file
(5) Paste the data into the template or master file
(6) Loop through all the files using the LEN function with the DO WHILE loop
Finally we can call our subroutine or macro every time we open the workbook to automatically transfer the data from the suppliers files to our master file.
Code and further details: https://www.exceltrainingvideos.com/how-to-transfer-multiple-rows-of-data-from-multiple-workbooks-into-master-workbook-with-vba/
Get 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

Видео Transfer Data from Multiple Workbooks into Master Workbook Automatically канала Dinesh Kumar Takyar