Formula to insert data from specified cells

[Essonc]

I am trying to build a macro button that I can use to format and replace blank cells with date from within the same report every month.

I'm ok on recording the Marco, I dont know what is the best formula, vlookup, ??? to format this report in the first place

The problem is there could be from 1 Catalogue number to eg 5,000

Also within the Cat No there could be from 1 Line item to eg 150 line items

So it needs to be able to distinguish between the Cat No's ans pull the relevant ones

I may be making this sound more complicate than it is (see example)

HELP?

Regards