Excel VBA Code Review and Consolidation

To review and consolidate an existing VBA for Excel program. It was developed bottom up and has a lot of repeated code segments that need turning into functions or subs to make it more concise and easier to develop further. The code is reasonably well commented and there aren't any recursive elements. The program basically acts as a userform and parser to generate an XML output that contains a list of furniture items and their parameters for passing to another program.