I am trying to find a solution to storing and accessing data in an organized manor.

What I am trying todo is be able to record payment records for clients who pay for a weekly or monthly service. I would like to be able to easily see all the payments for that particular client (possible by filtering I believe, correct me if there is a better way). The next step I want is on another sheet to have that client with the date of last payment they made aka search all of the payment records for that client and then return that clients last payment date. Do I need to write a macro or something like that? I really have no idea and would take any suggestions on how to build the workbook as I am starting from scratch. I have already built a vlookup to pull in all the member info off a generated member/client ID.

Thank you in advance.