Macro To Extract Data From Multiple Workbooks To A Single Sheet - Excel

Hi im still new to the forum and need help with MACRO.
I have multiple workbooks that i need to have data extracted from a single sheet and copied to a master sheet as a monthly reporting tool. Only 2 types of data are extraced and copied, the total count and the total amount. I have attached a sample of the master sheet and the various workbooks that date need to be extracted and copied.

Just a background i always works with formula but have limited knowledge about VBA and macro. Any help on this one is greatly appreciated.

Thank you.

Originally Posted by arlu1201

You will need to explain in detail, what you require and what data needs to go where. You need to specify the criteria and where to find it.

Hi

Users enter various data in the reclass, service.messages and MM.Approvals workbook. However only 2 Data type needed to be extracted, Total count and Total amuont . Extracted data are then posted and segrated to varous transaction type indicated on the Master file. Criteria entered on the Master List is the date range. see attached for illustration

Any help is sincerely appreciated. Thank you.