Multi-Worksheet results needed with Rules applied

4 Worksheets, Text oriented, no numbers, no percentages

I would like to have a specific "by-name result" posted to a separate worksheet, within the same workbook, based on the result of the text entered by the user. I have it working 50%, but I am looking to mass produce the formula congruent with the Main Spredsheet.

Example: person data sheet with the text "paid/not paid/pending" variable is in cells J3-J258 for each registrant. Based on the result of the text entered in cells J3-J258, I need the specific result "not paid" to produce that registrants entered Name from cells B3-B258 auto-filled in my Worksheet titled "Registrants Not Paid" in no specific order.

This formula partially works, but will not Copy/Paste and increase in value with each cell vertically.

=IF('Registration Data - ALL'!J3="not pd",'Registration Data - ALL'!B3,"") (Note= The resulting cell will remain an empty result "" unless the variable "not paid" is entered in the data worksheet)

How can I copy/paste the formula and auto-increase the cell J4/B3, J5/B5, J6/B6etc...


Thank you for your wisdom.