Excel is senstive when it comes to creating names. There are many restrictions on naming excel sheets. If excel does not like the name, it just create a blank name. It will not show an error as I have included an error trapping on the code. Having known this issue for some time now, I have inlcuded on the code to delete any names which are not valid names(sheets) from the workbook. So, when ever you run the code, it will delete these empty sheets. If you see any sheet which is not company name, let me know and will have a look again.