Auto populating a cell with text from another cell

Hi all

I am after some assistance, please.

I have a spreadsheet that I would like to use to record student results. Sheet 1 is a summary sheet. Sheets 2-6 contain results for each different subject.

When I enter student data into sheet 1, I would like the text entered to copy and paste into corresponding cells in another worksheet.
E.g.
If cell A3 on Sheet 1 = 000111222, I want that data to automatically copy and paste into cell A3 in Sheet 2.
or, If cell B3 on sheet 1 = Mary, I want that text to automatically copy and paste into cell B3 in sheet 2

I would then like data from other sheets to copy and paste into sheet 1.

E.g.
If cell G3 contains text (list of 6 possible results from a drop-down menu), I would like that result to copy and past into a corresponding cell in sheet 1.

Hope that all makes sense. Thanks in advance.

Thanks for the quick reply. I have attached an example of what I'd like. Hope it explains things clearly enough.

Thank you so much.