VBA to include offset

Hello everyone - - happy monday! right?!

I'm working on an Excel file that is a summary of updates on a list of projects that are currently being worked on. Columns A to L, see attached example file. In the attached there are two sheets, the FullSummary is the main sheet and the other, Example, is what I'm looking to accomplish via VBA and offsest.

For the first project in the list on FullSummary, A2 - L2 contain the basic info. What happens is we insert a row and put a comment in Cell C3. The next day if the project is still open we insert another row and put the latest comment/update in C4, again the next day in C5 and so on until the project is complete.

What I'm hoping to do is use offset to find the last update from column C and place it along side the value in A2, L2, C7 (see the Example sheet for what I'm looking to do).

Then the next row of my Example sheet would be: A8, L8, C11...and so on.

Would someone be able to assist with some code that would perform this? I'm thinking that offset with finding the last empty cell..etc. Any thoughts/suggestions? Thanks and enjoy your day!