Did you that you can drap and drop a VBA module from one workbook to another? With both workbooks open, click down on a module in the VBE and, while holding the click, move the cursor to the module list in the other workbook and release. This actually does not move the module, it makes a copy! So, open your projects and start consolidating your modules in a master workbook. HTH!
Excel For You 