I had a master worksheet with a long list of clients to monitor their payment
received (Jan to Dec).

clients name Jan Feb Mar
Peter
John
Albert

At the end of the month, I will received a list of clients who had made
payment for the particular month. How can I transfer this info into the
master worksheet. I cannot just copy as not all clinets made payment for that
month.