Generating Individual Save Names

Hi,

I have asked this question previously however I must not have explained myself properly as the answer didn't rectify my problem.

I have attached my Spreadsheet which I am having trouble with so you can see what i mean. Basically I have individual salesman who will be using this. I have a drop down in B2 with all the salesmans names.

I want the salesman to be able to press the save icon which in turn saves to a shared drive. I will have a folder for each salesman.

My question is.....When I press save is there a function whereby it will automatically save to the salesmans folder who's name has been selected from the drop down in B2. Not only that but the save name is taken from B3&B4 - eg Paul Johnston's folder Save Name:Georgesons Deal Stacker Lee Cox KF03CYP.

Any help would be greatly appreciated.

Thank you.