Formula to copy information from one worksheet to an overview sheet

HI,

I have a set of sheets in one workbook. I need to create an overview document to give a snapshot view of the agreed information held on each individual sheet.

I need a formula that will copy the information from each sheet to the overview sheet. Please see attached.

In the overview sheet, column B (cell b4) works fine with the formula ='1'!b1:d1 and so on - this information is always going to be a number.

The other sections will be a mixture of text, some numbers, some dates. When I use the formula above I get a #VALUE result.

Please see attached. I have filled in some test information in sheet "1".

I'm sure that there is a simple answer, but being Friday afternoon, my brain is not giving it to me!

Thanks in advance.

J