Sift data & re-populate whole rows of data matching certain criteria on another tab

I have a spreadsheet where every row is another customer, (and the following columns are notes or dates, or dollar amounts) column D identifies that lead source.
I would excel to sift that sheet of data, and repopulate each whole row of data on another sheet that all has the same lead source (column D).
It would be like filtering, but it would be constantly filtering and updating as the data on the primary spreadsheet is added to, modified, or deleted from.
End game, I just want to go to a tab that has a real-time view of the customers and related details specific to a lead source.

Not sure if I posted this request for help in the right forum/category.

Thank you all in advance!
-tommy

I took your advice and am super excited to learn pivot tables, but will admit i struggled. I continued to search for simpler solutions and found the query function accomplished my goal very simply! ...actually i couldn't believe how simple it is and plan to use that function A LOT more. Thank you for your help which I'm sure with your experience would probably do more for me than I could imagine. You rock!