Loop through a range of cells which display the filenames to be opened

[Miche25]

I have a master spreadsheet on sheet 1 in cells D4:D22 are the filenames for the csv files to be opened (the filenames change each month, however the folder where the files are held stays the same). How do I write a macro to loop through each of the cells in range D4:D22 - to open the file - copy from cells A7:to the right then down so all the data is copied and paste into the master spreadsheet on sheet2 then close the csv file, open the next csv file in the range do the same copy and paste, however paste at the next available row in the master spreadsheet - sheet 2.

Many thanks