Formula needed to fetch data from different worksheets and include adjacent cells

Hi everyone, I would be very grateful if someone can help me with a formula.

I have a spreadsheet which is used for tracking staff holidays and sick days.

I have a main worksheet where I manually input data and then I have a tab at the bottom for each member of staff. At the moment I am manually duplicating from the main worksheet to each staff member worksheet.

Each member of staff has a code and this is referenced on the main worksheet.

What I would like to do is create a formula that would look at the main worksheet and then pull in the data to the staff tabs. There is also data adjacent to these cells which I would like to pull in such as notes.

All the data is in the same format so there is consistancy.

Help!