After a quick look at your workbook I would suggest it isn't the macro that's dragging the workbook down, it's the formulae you are using.

You have an excessive amount of volatile functions, mainly INDIRECT().

Your workbook is over complicated many sheets and tables are duplications of data already in the workbook, this combined with the volatile functions used to create them is a recipe for failure.

This might seem hard on you, but your workbook needs serious reorganisation.
There is no point in trying to find a solution to a situation that should not exist in the first place.