Formula to Calculate Ratios

Hi everyone,

I am fairly new to spreadsheet and need to develope a simple spreadsheet that will present a actual vs budget % for certain clients on a weekly basis.

It is currently taking me forever to remap my formula each week when i have populated my actual vs budget data.

On Sheet 1 it has my data and on Sheet 2 is where my ratios are presented with graphs.

On Sheet 2, the ratio is presented in one cell with a formula that calculates based on two cells adjacent to each other on Sheet 1.

I am currently running my report horizontally across the spreadsheet.

The problem is that when i add in another week running horizontally across my spread, the formula can not be dragged across as it does not jump by two cells.

I have attached a example of what i mean just incase i have confused everyone.

If anyone have any suggestion to make things simplier and time saving it would be greatly greatly appreciated.