VBA code to place formulas

[Lorlai]

I have some code that works great for when my data is on the same worksheet. I want to leverage this so that I can keep the data on two worksheets and have a new worksheet for the formulas. I am having some difficulty, however. Is there a way to take this:

'code courtesy of [URL="http://www.mrexcel.com/forum/member.php?u=26558"]Norie[/URL]
    Dim wsnew As Worksheet
    Set wsnew = Worksheets.Add
    
    wsnew.Range("A1:BC200").Offset(, wsnew.Cells(1, Columns.Count).End(xlToLeft).Column + 2).Formula = "=A1=A203"

And have it compare the columns for two different sheets? So that it would become ='Sheet1'A1='Sheet2'A1?

Thank you for your help!

 

[wigi]

'code courtesy of Wigi
Sub ComparingSheets()
    Const sCell As String = "A1"
    Sheets.Add.Range(sCell).Formula = "=Sheet1!" & sCell & "=Sheet2!" & sCell
End Sub