What Formula can move the cell in the formula to the right?

Hello,

I'm looking for a function or button that will allow me to update the cell # to the right in a formula every time I press the button or run the macro or function.

='C:\Users\312583\Desktop\[INVR.xlsx]RI'!$Q$8 (this month) -----> ='C:\Users\312583\Desktop\[INVR.xlsx]RI'!$R$8 (next month) -----> ='C:\Users\312583\Desktop\[INVR.xlsx]RI'!$S$8