I’ve a requirement as follows.

The data from 14 tables needs to be dumped into one table
While inserting the data, the columns’ values are to be calculated based on calculations
The calculations involve different columns from different tables.
The number of rows in the each of the 14 tables could be around 50000

Please suggest the best way to do this data transfer from 14 tables to one table.

Thanks in advance.