Pull info from multiple workbooks to generate a report

[starbucksfan]

Hello all,

I'm new to the forum and to VBA in general, I was hoping to get some assistance as I'm a complete novice.

I have a folder on a Network drive that we house multiple .xlsm files in. The files itself are all the same and very basic. B2:B4 have title fields and C2:C19 have data fields which values will change every day.

I was hoping that I could pull the basic data from these fields and generate a new workbook with all the files in the folder and label it Reports.

Any help would be great thanks!

 

[starbucksfan]

https://imgur.com/a/osvDG

image of the form

 

[Bond00]

This thread has code that will help you at the bottom, but also if someone knows the answer to my bottom question there please help.
https://www.mrexcel.com/forum/excel...tml?highlight=Sum+cells+multiple+files+folder