Hi, I've been searching the site and could not find anything specific to resolving my issues with autofill, so any help is greatly appreciated!

I have 2 sheets:
"Data" = Where all the daily numbers are input
"Weekly" = Where I'm trying to get a weekly total from pulling numbers from the "Data" tab

In the "Weekly" sheet, I have columns labled as follows:
Column A, Row 1 labeled: "Week"
Column A, Row 2 and forward labeled: "week1, week2, week3, etc."
Column B, Row 1 labaled: "Total"
Column B, Row 2 FORMULA: =SUM(Data!F3:F9) which is the total sales for the 7 days

How do I fill the formula to where column B, row 3 in the "Weekly" sheet takes the total of the next 7 days instead of me having to manually type in "=SUM(Data!F10:F16)"?