Change how excel auto adjusts formula down a column

I'm creating a workbook that calculates power demands when appliances are switched on throughout different hours of the day. I've used this formula to gather data from two other sheets and insert a s...