Conditional copy of specific cells to another sheet

there are a few threads related to conditional copy but none are addressing the issue I have.

Have a master sheet , Would like to copy specific column values ( along with the cell formating) to another sheet in the same workbook if there is a "X" in a specific column.

there are multiple columns with X to be copied to mutiple worksheets

Sample file attached
For example Would like to copy from Master sheet to a sheet "Ent App" columns Number and Title based on the "X" in the column Ent App.Would like the formating of the cells to be the same as in the master sheet after copying.
Same for all other columns in the worsheet.


this is the first time with excel macros....Any help appreciated.