Simplification of macro code

Hi there

I am busy designing the workbook (that I have attached), that, through the use of the 'master' worksheet, creates a copy of the reciept as well as update the individual client account with the data generated by the 'master' reciept. The idea being that I will only need to edit my 'master' copy, and for the workbook to complete the job for me.

This has been achieved in the workbook I have attached, however, as you will see by the code, to simply do this for one account results in a large amount of code. There will be 80+ clients once the full client account list is included...

Can anybody suggest a method of looping the code to complete all worksheets, regardless how many there are, as long as the account is referenced in the 'master' reciept?

Thank you for any help in advance. BTW: please note if you test it, each worksheet is saved into an individual file currently set as c:\temp. Also there is an built-in protection that demands that the total quantity amount cell = the amount cell.

I really would appreciate the help
Regards,

PVANS