help to make moving conditional formatting

hi,
i have posted my problem here many times but unfortunately, i could not get concrete solution.
I have four sheets in one excel file viz. main requirement, aggregate result, availability and surplus/deficit. With the help of this forum i was able to apply conditional formatting according to my requirement however each month i have to either delete last month and add new month. To apply conditional formatting, i have named in surplus/deficit sheet. if i delete that column next month the entire conditional formatting will be off. so how can i make this function fix.
to make the problem simple i have attached the sheet.

BR
birkhe