I got this working. A bit clunky so I think I'll just go manual on this one.
So as I said I had a design table gathering the dimensions I want. I now have a second spreadsheet taking the values from the design table and looking up my values. On another sheet I have formatted the values the way I want linking to the look up sheet. Then I pasted the sheet into a drawing sheet, Voila!
To get the values to update I need (f2, enter) each cell. Clunky as I said.