Turn off Automatic Formula Calculation for Just One Sheet

I have a macro that creates a report by loading a csv file into a sheet named "Data". The macro formats this data and puts it into "Sheet 1" and generates a PDF. Depending on if the csv contains the name "summary" in the tile, it will format the data and put it in "Sheet2" and generate a separate pdf. What I would like to do is have the macro be able to just run once and it automatically load first csv file into sheet1, step into the second macro (i.e. it would overwrite the data in Data tab), prepare Sheet2 then print to PDF Sheet 1 and Sheet2 into one merged report. Obviously, when the summary data gets loaded into the Data tab, this changes all the linked references in Sheet1, so I need a way to turn the automatic calculation off prior to running the Sheet2 macro.

Not sure if any of that made sense, but hopefully someone can help!

Disregard. I found it.

Worksheets("Sheet1").EnableCalculation = False