Copying closed workbooks to a new workbook

[acousticlife81]

I need to be able to have individual sheets from different WKBKS to link data to another WKBK which is my dashboard.
What I am trying to achieve is I need is to be able to open all WKBK'S in a Folder automatically and import the data, sheet1 from each WKBK so that the sheets copied will reference to the dashboard WKBK.

Thank you,

-J