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...