I am new to VBA programming. I hope someone can assist me. At the end of each production day the individual assembly areas will update a workbook with their daily finishes. Management has requested an Excel workbook that would collect and display all of the daily finishes from the assembly areas. There are 3 different assembly areas, each with their own workbook. The individual workbooks are called "Small Assembly 2018", "Medium Assembly 2018", and "Large Assembly 2018". Each of these workbooks contain a separate worksheet for each month, Jan 2018, Feb 2018, etc. All of the worksheets are formatted the same. The day of the month is displayed in in columns D5:AH5. Under each day of the month in D6:AH6 is the "Plan" for each day. In D7:AH7 is the "*** Plan". In D8:AH8 is "Actual". This is were the daily production numbers will be entered. In D9:AH9 is "*** Actual". The labels for the 4 sets of data are in C6:C9. These workbooks all reside in a folder at C:\Building B\Daily Production. Each morning our director wants to execute a spreadsheet called "Daily Production" to see how each assembly area did the day before. This spreadsheet resides in C:\Management\Daily Reports. The report date will be in C1. The data from the individual workbooks will be displayed: Small assembly - A4 "Plan:", B4,"___", C4 "Actual:", D4 "____", E4,"*** Plan:", F4 "____", G4 "*** Actual:", H4 "____". The data for the Medium line will be formatted the same way in Row 9. The Large line will be displayed in Row 14. I summary, the management workbook will need to get data from the individual assembly area workbooks based on the date.