I need to copy the info from Sheet1 a11 to Sheet2 a4, but then the next
entry is Sheet 1 a12 to Sheet2 a 24, Sheet 1 a13 to Sheet2 a44 etc.... with
the spacing being the same number of cells apart.

='Sheet1'!$A12 goes into Sheet2 cell a24
='Sheet1'!$A13 goes into Sheet2 cell a44
='Sheet1'!$A14 goes into Sheet2 cell a64

I want to be able to paste the formula into Sheet 2 as there are 8 different
items that I need to import per grouping. Any ideas?

Bossman