Hello,

I have a bunch of different sheets that will all have the same information input into each sheet in the exact same place on each sheet. I would like to know how to get all of those pieces of information into one summary sheet within the workbook. I tried something simple which I pasted below. It worked fine when I kept the range simple like ("a1") but when I altered it to include most of a row ("A1:E1") it didn't show anything. Suggestions?

Sub PopulateWithData()
Worksheets(1).Range("B4:F4").Value = Worksheets(2).Range("A2:E2")
Worksheets(1).Range("B5:F5").Value = Worksheets(3).Range("A2")
Worksheets(1).Range("B6:F6").Value = Worksheets(4).Range("A2")
Worksheets(1).Range("B7:F7").Value = Worksheets(5).Range("A2")

End Sub
Thanks!