Here's ONE WAY....
Below Sheet "Master" Shows the Contents of Sheet "C" AFTER Selecting C from dropdown in Cell C2 AND THEN Running the Macro Foo...
| A | B | C |
---|
Select SheetName of | | | |
Data Desired >>>> | | | |
| | | |
| | | |
XXX | YYY | ZZZ | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: right"]233[/TD]
[TD="align: right"]422[/TD]
[TD="align: right"]153[/TD]
[TD="align: center"]7[/TD]
[TD="align: right"]204[/TD]
[TD="align: right"]446[/TD]
[TD="align: right"]369[/TD]
[TD="align: center"]8[/TD]
[TD="align: right"]377[/TD]
[TD="align: right"]145[/TD]
[TD="align: right"]219[/TD]
[TD="align: center"]9[/TD]
[TD="align: right"]269[/TD]
[TD="align: right"]339[/TD]
[TD="align: right"]309[/TD]
[TD="align: center"]10[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]398[/TD]
[TD="align: right"]208[/TD]
[TD="align: center"]11[/TD]
[TD="align: right"]422[/TD]
[TD="align: right"]318[/TD]
[TD="align: right"]282[/TD]
[TD="align: center"]12[/TD]
[TD="align: right"]422[/TD]
[TD="align: right"]318[/TD]
[TD="align: right"]282[/TD]
[TD="align: center"]13[/TD]
[TD="align: right"]422[/TD]
[TD="align: right"]318[/TD]
[TD="align: right"]282[/TD]
[TD="align: center"]14[/TD]
[TD="align: right"]422[/TD]
[TD="align: right"]318[/TD]
[TD="align: right"]282[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"]422[/TD]
[TD="align: right"]318[/TD]
[TD="align: right"]282[/TD]
[TD="align: center"]16[/TD]
[TD="align: right"]422[/TD]
[TD="align: right"]318[/TD]
[TD="align: right"]282[/TD]
[TD="align: center"]17[/TD]
[TD="align: right"]422[/TD]
[TD="align: right"]318[/TD]
[TD="align: right"]282[/TD]
</tbody>