I have a main sheet with lots of data and I need to copy and paste every single row to an individual sheet with a specific format. sorry for the poor explanation not that good in english. Here is an example, Once again I apologize I tried inserting a table but I couldn't understand how.

Main sheet (how it looks like)
a1 data1 data2 data3 data4 data5 data6
a2 data1 data2 data3 data4 data5 data6
a3 data1 data2 data3 data4 data5 data6

new sheet named a1 (how it should look like for a1)
data1 data3 data6
data1 data3 data6

then for sheet 2 named a2
data1 data3 data6
data1 data3 data6

I have over 250 rows and 24 columns. It is very exhausting to copy and paste manually. please help.

Really sorry for the bad explanation i am not good with english