So all y'all need to know is I have 3 sheets, 2 of those sheets have raw data that will have 1-5 additions made (1-5 new rows) every day.

the 3rd sheet has to have some raw data from sheet 1 and 2 in a specific order.
right now I am either manually copying the 2 rows (one row from sheet 1 & 2) into a predetermined area OR single cell calling with ! ::: and the rest of my sheet 3 fills out, however, I would like to streamline this a bit.

I want to pull an entire row all at once with a formula, so that all I would need to do is change the row in the formula from row 14 (for example), to row 15 and have all of the cells containing data from row 14 pasted on sheet number 3 change to all the cells from row 15.

if this is a very common thing please let me know how I can google this. or even a youtube video.

I don't want to have copy paste because I don't want coworkers to TOUCH the raw data (sheet 1 & 2), I want them to -only- touch sheet 3.

******The best case scenario would be a cell above the function that they can type a number (1-XX) and the formula pulls from that cell to decide the row.




TLDR: how do I copy an entire row to a new sheet with just one button/formula.