Need Worksheets to populate with new entry based on drop down selection from master list

I need to be able to do several things with this spreadsheet. First, when a new stage is selected from the drop down menu in a row, I want the entire row to adopt the formatting of the respective choice. For example, when quoted is selected from the drop down menu, I would like for the entire row to have the color formatting in cell A1. Also, I want all of the worksheets to show the all of the rows that are in each respective stage. So for example, if I change cell H10 from need mockup to mockup sent, the table in the mockup sent worksheet will now add this row. Every worksheet will pull the all the data from the Entries worksheet based on the stage that it is in. Could someone please advise on how I make these updates? I don't know if I need pivot tables or what... Thanks.
Names and numbers have been altered in worksheet to exclude sensitive data.

=INDIRECT("H"&ROW())="PO resolved" <-- do similar for each type of format (could not get "Quoted" to work though).

Thanks. Do you also know how I could get each worksheet to automatic pull data from sheet 1 as it is updated. For example, I would want the the mockup sent worksheet to update when ever I moved an entry from the dropdown into mockup sent. Could you please advise where you entered the indirect formula that you used?

The format is placed in the first part of Conditional Formatting.

(See image)

Once you click ok, you are returned to the second image part of Conditional Formatting where you can set the range of cell to format.

It still won't work. I click on conditional formatting, enter the formula you provide, click ok, and that's all that happens. How do I get to the point where I specify formatting. Man, I can't stand excel.

In the spreadsheet I did for you, based on your information, you just need to click on HOME tab then select CONDITIONAL FORMATTING and view what I setup in it. There is also the two images I made showing where on the Conditional Formatting the formula is placed and where to specify the range that it will affect.

I've gotten this to work now. I just needed a little patience. I really appreciate your help on this one. I certainly have a lot to learn about Excel - I don't really understand the logic of a lot of the formulas. Do you know of any good resources to really gain extensive knowledge of gain from beginner to advanced?

Thanks. I will definitely check this out. I have one more question. I set up a custom sort by color in the stage column. Unfortunately when I change the status of a cell, from quoted to need mockup for example, it will change colors, but won't automatically sort it with all the other entries in "need mockup" status. I have to go back into sort, select customer sort, and then click ok again. I thought perhaps recording a macro to create a button that will allow me to quickly sort would do the trick. What do you think? If this will work, Could you also please advise how to display the macro button? It doesn't seem to show up under my developer tab.

I will start another thread, as that is another topic. But I do have one more question in regard to conditional formatting. How would I alter the indirect formula to make it highlight a specific column/s (status and date updated column) rather than the entire row?

Hello Jeffrey,
I did start a new thread in regard to my macro question. I still have an outstanding question left about conditional formatting and how I can format the spreadsheet to update select columns with a specific color rather than the entire row. Could you please advise if should close out this thread and start a new one. I'm kind of new to the site and want to assure that I adhere to all policies and procedures. Thanks in advance for maintaining such a great site. It is already proving to be a great resource

Hello Jeffrey, I figured this one out. At this point, I simply think that it is a better idea to have a single cell change to a specific color when the drop down is updated. See attached. My programming related question, which I have opened another thread about, is how to make the rows automatically sort when updated. For example, if you update H10 from need mockup to mockup sent, I want that entire row of data to move down to row 32 so it will be sorted with the other rows that reflect "mockup sent" in column H.