Automatically copying a data into another worksheet in same workbook

[Raju Radhakrishnan]

Hi,

I have prepared an excel file where I am stuck a little bit. I am having an idea but I just cant implement it. I have attached the excel file and il now share my idea.

I want a macro in the excel file to seggregate all the vessels into other worksheets in the same workbook. For Ex: First vessel name is = Maersk Dabou. So i need another sheet to be automatically named "Maersk Dabou". and automatically create an hyperlink in the errors column. For Ex: A16 should be an hyperlink cell and by clicking it i should go directly to that sheet.

I have many files such way. So i need a macro which would segregate it that way. I hope am clear. Kindly reply if not.