Copying information from worksheet to another

Hello

I am trying to do an excel file that has one main sheet where all of the information from sheets 1, 2 and 3 (Data1,Data2,Data3) with respect to engineer in question will be copied once a name of an engineer is set and button has been pressed.

I have attached an excel file to give you some clue what i am trying to achieve.

On the sheets, Data 1 - 3, i have information regarding different engineers (totalling about 500 rows on 8 columns on each sheet) and by defining an engineers name on the Main sheet and pressing an execute button, it would retrieve all the information (copy the respected row) on that engineer from all the data sheets to the Main sheet (as depicted on the example file).

I am relatively new to VBA, but i do know the basics. I am looking for a little guidance as how this could be accomplished (if it is possible).

hi, gini, please check attachment, hope this helps