I have a Name range like following

MyName
OFFSET($B$12,0,0, COUNTA($B$12:$B$65000), SHEETS("MYSHEETS").RANGE($D$12))


Because the name range is changed base on ($B$12:$B$65000),
SHEETS("MYSHEETS").RANGE($D$12) values.

I need calculate the summary like average, total per row and per column.

Are there any way to access dynamic range relative cells?

Like MyName.cells(1,1) can reference cell "MYSHEET"!$B$12.

Thanks millions for any information,