Exporting From Old Table To New Tables

I've been tasked with the following: Export data from old table, to newly created table(s). I say tables because there's three destination tables total, and only two source tables. The two old tables are virtually the same, so the new table will be a combination of the two. More importantly I'll need to chop out some data from the old tables and create new details with them. As you can see, the old table was very "flat" in the sense that they kept adding new fields for bits of detail data (10 for one type of detail, 15 for another type of detail). I'd like to house that data in separate linkable tables. This is an example of the old and new data structure:

OldTable1 (SOURCE)
Name | Acct | Detail1Min | Detail1Max | ~~~ | Detail10Min | Detail10Max | DiffDetail1Min | DiffDetail1Max | DiffDetail1Rate | ~~~ | DiffDetail15Min | DiffDetail15Max | DiffDetail15Rate |

OldTable2 (SOURCE)
Name | Acct | Detail1Min | Detail1Max | ~~~ | Detail10Min | Detail10Max | DiffDetail1Min | DiffDetail1Max | DiffDetail1Rate | ~~~ | DiffDetail15Min | DiffDetail15Max | DiffDetail15Rate |

| | |
| | |
VVV

NewTable (Destination)
AutoID | Name | Acct | TYPE | * Newly created field so I know which table it came from (OldTable1 or OldTable2?)

NewTableDetail (Destination)
AutoID | NewTableID | DetailMin | DetailMax |

NewTableDiffDetail (Destination)
AutoID | NewTableID | DiffDetailMin | DiffDetailMax | DiffDetailMax |

In the new data structure, the AutoID from the main table (NewTable) will link to the two newly created detail tables using NewTableID.