Okay the formula I posted will copy the values of A1 in sheet 1 to A1 in sheet 2. Dragging it to B1 does B1 sheet1 to B1 sheet2 etc.