This worked when I used it on a test spreadsheet where the Tabs were
named Sheet 3, Sheet 4 and Sheet 5, but when I tried to use it on the
real file where the corresponding Tabs were named for example: North
Lane Apts, Sherri Lake Apts and Carriage House Apts, it would not
recognize the Sheet name probably because my formula is set up to call
them Sheet3, Sheet4, Sheet5. When the Macro started to run it prompted
me at every step to select the workbook and the worksheet that I wanted
to updated the values from. How can I get the Worksheet names included
in my formulas. There are many worksheets I just used 3 in my test
file.

Again what I was trying to do was to pick up information from a couple
cells from multiple worksheets and summarize it on one worksheet, with
each apartment complex having it's own line.

Here is what my macro looks like now:

Dim i As Integer, Sheet As Worksheet


Range("A1").Select
For i = 3 To Worksheets.Count Step 1
ActiveCell.FormulaR1C1 = "=Sheet" & i & "!R4C2"
ActiveCell.Offset(0, 1).Range("A1").Select
ActiveCell.FormulaR1C1 = "=Sheet" & i & "!R3c1"
ActiveCell.Offset(1, -1).Range("A1").Select
Next i
End Sub

Thanks for any help.