VBA to avoid - "indirect" Formula

[leopaulc]

Dear All,

I want to compare huge database from different sheets according to the sheet name.

Problem faced..
1. From the selection dropdown, the sheet name has to be selected, and it should come to the sheet (Data1, Data2 ....) for the graph reference data.
2. I am using INDIRECT formula to pull the data from relevant sheet. The file became heavy by 2 MB with 5 data sheets.

Requirement....
I need, the entire data sheet to be copied from the selection -controlled by dropdown menu - (specified sheet range..) that is a must - VBA required for copy the data....

I am attaching the sample file for reference.


Please help..

Regards,
Leo Paul