Pulling rows from a master list into separate pages

Alright, this is my first post ever, because I have been working on this for ages and getting nowhere- please help.

I don't have a lot of experience with macros and VBA so go easy on me, but I feel like this *should* be easy.

Note: I am only uploading a small sample of the entire excel page this will be implemented in, so that I could focus on just this one problem.

Basically, I have one big "equipment" page in which (in the final version) I will have dropdown menus that select the sub-process that the type of equipment applies in. I have tabs for all of the different sub-processes. I basically want the user to input all the data on all the equipment on the main "equipment" page, and then from the selections of the drop-down menus send all that data to each separate sub-process sheet.
I can get it to work so that if there are 54 rows in the main equipment page, and 4 of those are "boilers," I can get 54 rows in the boilers worksheet with 4 boiler data points and blanks for the rest of everything else- but I just want there to be 4 rows in the boiler page.

I've attached the experiment sheet. Sorry about the conditional formatting colours and some of the names might be weird from what I've already tried, but PLEASE, any help would be GREAT.