Compile data from lots of sheets into one summary sheet

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?

Please Login or Register  to view this content.

Thanks!