Copy range from the worksheet preceding the active worksheet

I need to copy a range of cells from a worksheet before the active worksheet. I can't use the name of the worksheet or its index number because these two things are always changing. So I need to reference the worksheet I want to copy from using only the active worksheet. My code looks like this:

Please Login or Register  to view this content.

So sheet "2" is my active and sheet "1" is the one I need the cells from. But I need to reference sheet 1 using the active sheet ("2")

I am not getting how I would do that by looking at your code. This copies from the active worksheet:

Please Login or Register  to view this content.

So how do you subtract 1 from the index?

Thank you so much for your time.

Oh perfect! Thanks, it seemed like a simple and reasonable thing to be able to do.

Thank you I will tuck all of this away for future reference.