I have a worksheet with information that I want to copy automatically into
columns on another worksheet. How do I do this? I got the formula that
someone gave out a couple of years ago:

=IF(Sheet1!A3<"",Sheet1!A3,"")

But I don't know how to use it. When I put this formula into the cell where
I want the copying to start, nothing happens, except the cell shows a green
upper left corner and the following appears in the cell: # REF !

Does Sheet1 have to equal the name I've actually given to my sheet (I've
changed the name of the original worksheet on the tab at the bottom)?

Can I start the copying of data on row 3 or do I have to start with row 1?