I need to write a macro or procedure to update multiple sheets

Hello,

I have attached an extract.

I have added columns and new formulas to certain areas of an existing workbook.

Each sheet represents a person. There are 30 people in this company and I need Excel to update all of the columns on each sheet where I have carried out the updates. Can someone help me.

Sheet 1 shows the new columns and formulas. Sheet 2 shows the old columns and formulas. Imagine another 30 of the same in sheet 2. Each sheet has a three letter code which is the crew members personal code.

I need a macro to update only columns and formulas and not alter the information imputed into the sheet.

Can this be done?

can someone help pls