Hi, I could really use some help on this!

Sheet 1: A matrix with date on top (7/4, 7/11, 7/18, 7/25, etc.) and client name running down the side (Company A, Company B, etc.)
Sheet 2: A constantly updating list that will contain a date (Column A), a client name (Column B), and a small string of text (Column C)

I'm trying to use VBA to automatically Index Match Match date and client name to insert that small string of text into the matrix on Sheet1.

Any ideas?

Thanks for any help