Hi, I have 63 separate files which are sent to our stores each month
and returned, and are identical in format. I have password protected
them also so our sites cannot alter the layout.

Each site name is entered in cell B17 and I have created a comments
section from rows 41 to 47 and wish to copy these rows from each file
and condolidate into 1 sheet (create a summary of all comments)

My skills writing macros are fairly basic and would value some
suggestions on how I can create a report which will extract the site ID
(B17) followed by rows 41 to 47 from each file.

Thanks,
Dean