Formula needed that will duplicate a whole row of data I input from one sheet into another

[tanyamoniq]

I have several spreadsheets in a workbook. I would like for my data for an entire row be copied from Sheet2 to Sheet1. I'm not talking about copying and pasting data, I would like a formula that will update the information in Sheet1 when I enter new data in Sheet2. I know you can enter =Sheet2!A2 but I need it to copy data for the entire row, not just one individual cell. I feel like this should be relatively simple but I can't figure it out and I can't find anything via a search. Can this be done? Can someone PLEASE tell me how? Thanks in advance for your help.

[Tony Valko]

I know you can enter =Sheet2!A2 but I need it to copy data for the entire row, not just one individual cell.

You can just copy that formula across the row as needed.

[tanyamoniq]

Each cell has a different format, some are dates, some are text and some are blank. If you copy it over, the formats don't come out right. And the blank ones end up with a zero. I'm sure I'm not looking at this in the right way. My mind is a little overcrowded today.

[Tony Valko]

Each cell has a different format, some are dates, some are text and some are blank. If you copy it over, the formats don't come out right. And the blank ones end up with a zero. I'm sure I'm not looking at this in the right way. My mind is a little overcrowded today.

My mind is overcrowded every day!

The format of the target cell makes no difference.

To eliminate zeros for empty cells:

=IF(Sheet2!A2="","",Sheet2!A2)

Copy across as needed. Then, you'd have to format the individual cells as desired.