Dave made a macro that consolidated multiple workbooks into one and it works excatly how I wanted it to. But, just noticed a small problem. After the workbooks are consolidated, it appears that some of the formulas and drop down menu's don't work. It is important to my project that the sheet is still functional after consolidated. Not sure if some of my marco's might be the issue on how I have them named.
I did read through the code and studied my formula's but don't know enought to do much.
I am waiting a phone call to pick my mom up from the hospital, so if I don't respond for a bit, that is the issue.