Get, Merge & Consolidate Data - Help Request!!!

[techzia]

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

[FDibbins]

welcome to the forum

without knowing the file name, and if the names are not the same/constant, what you want is not possible with a regular formula

[techzia]

Thanks for the immediate response FDibbins.

I need some vba code not in formulas. Is it possible?

[FDibbins]

my vba sucks, but i think even with vba you will need to know the file names

[techzia]

OK... I found out how to fetch the data from other files from the folder.

But now i am stuck at...

I have a workbook with 8 sheets and named as "Mon" to "Sun" which are 7 sheets and 8th sheet is Consolidated. Please let me know how to merge all other sheets data into consolidated sheet?

Thanks in advance.

[esmithqg]

Try this?

Please Login or Register  to view this content.