We have 200 Excel survey workbooks collected in 1 folder
Our Director wants to collect all the responses that are recorded in the Summary Sheet of each of the files (there are many other sheets in each of these workbooks)
Specifically B9:K9 from Summary in each of the 200 files into 1 workbook = 1 sheet = Survey Summary
I have been playing with some of the VBA file combine codes posted but the ones I am finding combine to one workbook and all the sheets are collected not appended as 1 sheet
Some of the code is based on workbooks being already open
I am looking for the code to
designate where the folder of 200 files resides
The specific sheet name
The specific cells in the designated sheet
TO
a new workbook with 1 sheet of all the 200 rows from each file
Hopefully I am making sense
Posted sample of summary sheet
Thank you