What I am trying to do is create one master spreadsheet. This is the only place where data is entered. I then have 3 other worksheets. (Master, PCIS, Purchase Order, BPA)

I have 5 columns (Date, Price, Service, Purchase Order, BPA).

If Price < $3000 and Contract = "blank" and BPA = "blank"
then copy the whole row to the PCIS worksheet.

I hope this makes sense.

So when they enter each row it can auto populate the other worksheets based on what it entered.

Thanks in advance for your help.