I need to be able to have individual sheets from different WKBKS to link data to another WKBK which is my dashboard
1. The first thing 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. i have attached an example of what I am trying to achieve.
Thank you,
-J
Bookmarks