Start clearing your code:

- do not use select
- do not use activate
- refer to the sheets unequivocally by using it's name e.g.: sheets("hotel') sheets("manager")
- dive into the VBEditor's help about loops : For...Next
- avoid errorhandlers