Paste range of formulas to a sheet using Personal Macro Workbook

I have a spread sheet, and I have a range of formulas on that sheet. I recently made adjustments to the formulas but there are a ton of one off versions of that worksheet. I want to be able to open any one off version of that workbook, run the macro, and my updated range of formulas will be pasted into that old workbook. But I am using the Personal macro file so that I don't have to open up the new file every time.

So basically, my plan is to paste my new range of formulas onto my personal macro worksheet. Then create a code so that when I open up one of my old workbooks that have outdated formulas, I will run the macro and the new formulas that I have as a range in the personal macro sheet, will be copied and pasted into a specific sheet on the old workbook I have open.

How would I go about doing this?

EDIT*** To clarify, I know how to use the personal macro worksheet. My question is strictly about the code for the macro.