pulling info from previous sheet to current with ever changing current sheet

[velthro]

Is there a function that will essentually read "value of this cell=cell a1,one worksheet back"?

something similar to =value(previousworksheet!G:G)

I add a worksheet every month and need to pull information from one of last months collumn into the current months sheet.

 

[velthro]

So this question is answered, I found the solution at http://www.cpearson.com/excel/sheetref.htm the solution is as follows.

Function RefOnPrevSheet(Addr As String) As Variant
Application.Volatile True
With Application.Caller.Parent
If .Index = 1 Then
RefOnPrevSheet = _
.Parent.Worksheets(.Parent.Worksheets.Count).Range(Addr).Value
Else
RefOnPrevSheet = .Previous.Range(Addr).Value
End If
End With
End Function

You can use this function to get the value of C5 on the previous worksheet:
=RefOnPrevSheet("C5")