Copy Columns

[aiverson]

I have a simple excel sheet that I use for inventory.
I want to copy the contents of 3 columns to another worksheet in the workbook to be used for inventory order tracking.
How can I autopolutate the columns in the 2nd sheet?
Meaning, if I add a product, it will show up in the 2nd sheet automatically?
Thanks for any and all help.

[Palmetto]

On sheet2, say cell A1:

=sheet1!A1

Copied down and across as needed on sheet2.

[aiverson]

Thanks for the quick reply.
Any way I can copy the whole column? (or mulitple columns)
Also, on sheet2 I get the data and then a 0 at the end of the text right justified.