I want to lookup the name of the worksheet and place the corresponding
department name in a cell of the worksheet

for example the worksheet name will be 1500 which represents department
"Aviation"

I have a department list sheet that would contain the group (1500 and the
respective department

Thanks