split excel sheet in to multiple workbooks based on the number of columns

I have a worksheet with 10000 records. For example, entire data in ColA-ColZ.

In that, ColA-ColB - GENERAL Information; remaining column contains site name with QTY.

I this case, the data to be copied into another sheet as follows:

1) the GENERAL data should be copied n first two columns.
2) qty of the site has to be copied next .
3) file name has to be site name how many number of sites that many workbooks has to created.

I have attached a sample workbook for your kind reference.

I hope someone will help me to solve this.

Thanks a lot in advance,

Hi sadananda1

Welcome to the forum.

It is not clear (to me at least) which of the 11 worksheets you wish to copy from.

qty of the site has to be copied

It is not clear which is the "qty of the site"

file name has to be site name

what is the site name?

file name has to be site name how many number of sites that many workbooks has to created

Do you mean that if the sites number is (say) 7 then you want 7 new workbooks? If this is correct what do you want them to be called?

I would like to help, but I do not understand.

Perhaps it would help if you gave an example of what you are trying to achieve?

Regards
Alastair