Creating an Invoice with different value on different client name (Newbie here)

Hi,
Thanks for prompt reply. Actually i had created job file recording as attached on 1st post. And the formulas and macros all i learnt through google-ing & copy & paste.

What i want it to be, it is actually like from the job file recording, whenever i type my customer name(will alter it again) it will follow exact quoted rates from another work book 1/ Quotation file.

I do it separately just to ensure that the file is not compact and heavy. Customer based might growing too instead of going down (means that more quotations will be need do) Previously my excel is load with over 100+ sheets, and it is corrupted. Hence, i maintain this way, and it is so far so good.