Autofill formulas across worksheets, rows and colums

Hi Bruce and welcome to the Forum.

Not sure I understand your question fully - it nearly always helps if you, when creating your question or later editting it, use the Add Files... button to upload a representative Excel file (without any personal data) to show your existing macro and data. 

I think you can use the Excel INDIRECT function here (combined with R1C1 referencing and ROW / COLUMN functions). Don has a tutorial on this (INDIRECT Function in Excel - Powerful Range References

In the attached file, I've tried to recreate what you said. The formula in A2 (and copied down to other pale yellow cells) in Sheet1 is: 

=INDIRECT("Day1!R"& 11 & "C" & 13 + (ROW()-2)*2,FALSE)

where the first bold bit fixes the row to 11. The second bit uses the COLUMN fuction (which returns 2 for a cell in column B) to give "skipping" by two columns right from 13 (column M) as it is copied across.

Likewise the formula in row 2 (in pale green cells) is (for B2):

=INDIRECT("Day1!R"& 11+ (COLUMN()-2)*11  & "C" &12,FALSE)

where this time it "skips" by 11 rows as it is copied right.

Hopefully this makes sense (and you can see which cells from Day1 the functions give) and you can modify it to suit your purposes. If this works for you, please don't forget to mark this Answer as Selected (it helps to guide others too)