Developing .CSV File

[sctraffic]

Hello,

Here is an outline of what I want to be able to do;

Take a .CSV file from one source - file 1.csv
Take a second .CSV file from another source - file 2.csv
Open a template file that contains equations that are based on information in file 1.csv and file 2.
Save 'Sheet' that performs equations as a .CSV file.

So far I am able to copy/paste from the source files onto sheets setup in the template. I was really hoping I could open all 3 files and 'move' the source sheets into the template, perform calculations, then save as new .CSV.

The problem I'm running into trying to 'move' the sheets into the template file is the sheet references break and equations are useless.

I hope this makes sense. File attached for reference.