Running vba code -> formulas return #ref

[Alina_T]

Pls help! After running a vba code (delete multiple columns, keeping some of its), my formulas from another sheet returns #ref.
I don't know how can I do in another way, I'm trying to create a report.
Thank you in advance!
LE macro for deleting columns works hard. do you have any suggestion to make it easier running? thank you!

 

[AlanSidman]

Cannot replicate your issue. I ran your macro in the attached and there are no #ref cells

 

[Alina_T]

you have to do copy paste for data in the last sheet to the first sheet - than run macro