Populating data From one sheet to another, relative rows

[mmp]

Firstly, my problem may be not knowing how to properly describe what I need.



I'm trying to make a master spreadsheet where all data is entered, then have that populate individual sheets based on criteria in an if statement.

I got it to work by referencing specific cells, but I need it to where it could by just referencing a column.

I would greatly appreciate any help. I've uploaded the .xls. I know my description skills are a little lacking, so please contact me if you need any clarification.

Thank you kindly.