Avoid #REF! error when deleting columns

Is it possible to avoid the #REF! error when deleting columns that are located in the columns before the formula? For example, I have a spreadsheet set up for my budget, and as a pay period passes, I delete that pay period's information (columns B:D in attached file); but I want the values in the next columns (E:G) that take its place to repopulate with those cells' values. As it is, after deletion, I have to then manually re-enter the missing references. Granted, it's only about 5-10 fixes, but it's still annoying to do on a weekly basis. I've tried INDIRECT and OFFSET, but I couldn't get them to work since I'm deleting columns that are before the columns in those references. A sample formula in my spreadsheet:

As I delete columns B:D, which all go together, I want the information currently in the next 3 columns (E:G) to replace those values. Then, I want D6, G6, and J6 to still call the same cells that are currently referenced in those formulas, but with the values that moved over. Is this possible WITHOUT macros? Because macros can't run in the mobile app.

I hope this makes sense! THANK YOU!

I don't want it to remember what was previously in columns B:D, I want to move the current values in columns E:G over to B:D when B:D is deleted, just replacing the values.

As Glenn said, if you keep the formula in G5 and G6, that reference the columns you want to delete it is impossible. Because you "wanting to remember" the values those cells had.

One solution could be copy columns E:G and paste in the same columns as values. Then delete columns B:D.

Or you could not delete columns B:D, just hide them.