Copy to Multiple Worksheets With Different Arranged Headers ROW by ROW

[foxpro]

I have a workbook with 10 worksheets.

The master sheet is called ("DataSource") and the destination worksheets "Dest1", " Dest2", " Dest3", " Dest4", " Dest5", " Dest6", " Dest7", " Dest8", " Dest9", and " Dest10" in the same workbook.
The master sheet ("DataSource") has 20,000 rows.

I want to copy data from a source worksheet ("DataSource") and paste it to all destination worksheets based on a column header in each destination worksheet.
Clear the content of the destination worksheets starting from the second row before pasting new data.
There is a condition for copying a single row each time and saving the result in a new workbook in the same folder.
After finishing the first row and saving the new workbook need to repeat the same process for the second row from the source worksheet until the last row in the source worksheet.

 

[Cubist]

1) How do you determine which row goes to which sheet?
2) Why the strange requirement saving after each row? This will significantly slow down the code
3) Unclear about the last setence about your requirement. What does "saving the new workbook" mean? Where is the new work book coming from?