I would really appreciate some help with this...

I am coding a macro to open all the workbooks in a folder, copy data from a
specific page in each workbook (the page in each workbook has the same name)
and paste that data into an open workbook.

What code would I use to tell my macro to open each spreadsheet in a
specific folder? How would I then tell it to close all the spreadsheets it
has opened?

Many thanks for your help,

Tristan