Excel 97 cell refer to sheet

I am trying to automate an entry in a cell to reference a certain sheet. I created a macro to enter data from an input box to cell B3. This is the same name as a sheet it creates at the same time. I would like to automaticly put the formula to refer to that sheet in cell G3.
Example: B3=Sheet1 G3= =’Sheet1′!J3.
Have I explained what I am looking for enough? I am stumped on this one.