Need a macro for naming manager

Hi,
I have an excel file in which I have different headings. I will be keepon adding/deleting multiple columns. So, every time I want to search for headings (Name and Value) and for that entire column I need to define in naming manager as

='Raw Data'!$C$2:INDEX('Raw Data'!$C:$C,MATCH(REPT("z",255),'Raw Data'!$D:$D,1))

Please help....

Attaching the file for testing...