Excel Configurator for Custom PC

Hi there, I am building custom pc's. I have about 100 components split into roughly 8 categories - cpu, ram, optical drives etc. I would like 2 things done - one a little more complex than the other. So first the easy one; Create an excel doc so that i can EASILY pick and list components from a list and automatically create a pc system displaying cost, profit and sales price. The more complex issue is this. On my website I have a pc customisation page that lists all cpu, ram, optical drives etc that I update via excel. What I want is that when I choose a system as explained above I will automatcally create price options for the customisation page. So for example my basic system has a cpu worth £100, it will then update the list of cpu's so that the £200 cpu has a value of +£100, the £300 cpu has a value of +£200 or the £50 cpu has a value of -£50. I don't know if this make sense. Your help is much appreciated. I have attached file shoing an example of what i would like created.