Update data from different sheets

[sachin3467]

Hi,

I'm new to Macro and VBA, I need help with the following task.

I wanted to pull data from multiple excel spreadsheet into one master workbook based on the courses and day wise. Instead of going through hundreds spreadsheet copy and pasted, is it possible to use Macro or VBA to perform this task? I'm using Excel 2013 & 2016. Attached you will find the master file and the two spreadsheets where i want the data to pull from and this process continue every end of the month so next data pulled under the last update data.Any help would be greatly appreciated.

thanks,

[arlu1201]

Hello sachin3467,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.