Hello, this is my first post to the forum and I am hoping someone would be willing to offer some advice...

This is a difficult question for me to put into words but I am trying to find a way to reference a cell on another sheet in two consecutive rows and then skip to the next row.

Here is an example and what I am looking for:

=Sheet1!A1
=Sheet1!A1
=Sheet1!A2
=Sheet1!A2
=Sheet1!A3... etc, etc.

I am currently using an absolute reference, copying it down 3 cells, then manually changing the last cell to reference the next in line. Is there a faster way to do this? I have to do this hundreds of times and it would be a real timesaver.

Thank you in advance!