Selected Sheet Range copy One after One!

[r_know]

Dear All,

I want export content as defined Range with following,

1. In Index sheet I have button where I want except Index sheet other sheets name shows in Userform. So I can choose from userform sheet which need to find range for export.
2. After selection sheet, each selected sheet B1 to O column last row criteria to find last row.
3. But Range copy B1 to P column based on O last row.
4. This range copy to new workbook; Paste in B1 as same format & Value (no formula)
5. Once first sheet pasted and second sheet criteria same B1 to O column last row criteria to find last row.
But Range copy B1 to P column based on O last row.
6. This copied in just below the last row of earlier pasted portion.
7. All selected sheet copied/pasted one after one in one sheet.

Can someone figure out? Thanks for your time

Reg, RLAttachment 11600

[r_know]

Can Any One Pls?

[snb]

Maybe here:

solutions