Insert columns based upon data using conditional formatting

I have a spreadsheet that I have to add 3 columns in the middle of the spreadsheet, lets say insert right before the Tax_ID column, if they do not already exist and 3 columns at the end for the file if they do not exist. I have to specific data in them if there is data in another column. A good example is... if there is a last name in column D, then I need to add 3 columns, with headers B_Type = P, C_Type = PHYS and D_type = N, if there is no last name then B_Type = G, C-Type = GRUP and D_type = N, If data in Company name has 'Hospital" then B_Type = A. C_Type = Anci and D_Type = N.... , the columns at the end would need to be added if they do not already exist and the data in those columns would always be the same... the headers would be PR_PRC,PR_AUTO,PR_PRD, that data unders the headers would be PR_PRC = "SDOC",PR_AUTO="#",PR_PRD="MD". I can send a sample of what it should look like, if that would be easier.

Yes that would be easier

Kind regards
Leo