merging two excel files into one

merging two excel files into one

I have two files with multiple worksheets in each that I would like to combine into one file. I want the formulas to remain but without the association to the old file.