copy cells from one sheet to an other if of a certain value

Hello,

I'm trying to copy data from one sheet to an other if Column F is of a certain value.
For example If cloumn F from the master sheet has a value of 1150 then copy all rows and column for those to the SRMDMC-1150 sheet with headers... Is there a copyif function?

Attached is my workbook.... I'll have to do this for all sheets as noted.

Thanks!!