Hi All,

I am working on a project which has *.xlsm files in a folder. The files are in the shared folder are on its own name its not fixed file name.
But each files has 7 sheets which are common in all the files in that shared folder. To be more clear the sheets names are "Mon" to "Sun"

People enter the data into the files which are in the shared folder.

I have another file on my desktop, all i need to do is to fetch the data from the shared folder.
I have a dropdown which has list from "Mon" to "Sun". Based on this selection all i need to is fetch data from the files from shared folder from the selected sheet.

I have a sheet on my desktop file which says "consolidated", the fetched data should populate and append to the "consolidated" sheet.

Hope i am clear, else please let me know if you need more information