Loop to copy the same rows from multiple files to a master file

Hi- thank you for replying.

Each workbook contains daily summary information for 16 different water monitoring sites (WM-01 to WM-16). I need to create a separate workbook which contains every day of information for just 1 site (e.g. WM-14).

For example, in the simplified attached workbook, I need to copy rows 16-18 (site WM-14) and paste this information into another workbook. This process needs to be repeated for all the files in the folder (about 100 and all formatted identically) in order to obtain all of the information from all days of monitoring for just site WM-14 in one 'master' workbook.

I therefore need a code to loop through each file, copying rows 16-18 of each and pasting them consecutively one after another in a master workbook.

All help, greatly, greatly appreciated!
Thank you!