Replacing A Block of Info using a reference cell

[allan.paterson]

I am building a Quotation spreadsheet.

All quotations are based on the same formula's (with variables I can adjust from pull down menu's).

However we make various sizes of similar items which use different base components.

I want to "replace" the based component data (3 columns wide by 7 rows down, always the same size) by referencing a single cell. There are 23 different base data "blocks", I've built the "blocks" of cells on a separate sheet with reference cell in the 1st column example;

Ref Column 1 Column 2 Column 3
8/9oz 0991619 Vinyl Tape 75mm Clear 0.0009
5962129 PE Film Cup 38mu 305mm 0.1047
8126100 492mm 8/9oz 280+18gsm 114.3000
8431108 67mm 4/8/9oz Btm Stk 210+24gsm 65.4800
8800404 Curl Lubricant - Hot Cups 0.0120
8800815 Ink SVK Cups 0.0568
8901686 Case Ptd 8/9oz Hot Cup Heavy 1.0000
9100091 Case Label 1.0000


I tried doing it with vlookup but that doesn't work as it can't replace a range of data.

I'm guessing it will need to be a Macro but that is not something I've done before.

Thanks.