Filter data from Multiple sheets and Paste into new Sheet

Hi,

I need help for,

I have multiple sheets said A,B, C and Master .

sheet A contains Different bike models say X in many rows, and same with Sheet B and Sheet C.

I need a filter on Sheet A, B , C for X and print all rows containing the model X , on the master sheet. . and every time it refresh itself when run program again.