This is just an example. A workbook contains 10 sheets. They are

Summary/Index/AA/BB/CC/DD/EE/FF/GG/Version

Now, user want to select data particularly D column from AA sheet to FF sheet. This is just an example. In real scenario a worksheet can contain n number of sheets and the code what I am looking is should not collect the values from the sheet1. it should collect the values as per the user wish and stop where user wants.

Hope this example is clear.

Thank you!