Link Names and Add Column

[aftabn10]

Hi, i am trying to build a report that will by a users entry in a userform, add the correct layers (Senior Manager to Agent Level) to all the required sheets.

I have attached a sample workbook, that might help to understand what i am trying to do a bit better.

I have a worksheet "StaffList" that basically gives you a breakdown of the structure.

What i would like is for example if u enter "L4 B" in the userform, then the L4 Report sheet will add the name in cell B2 and then from columns H onwards add the "L5" that belong to L4.

For example L4 B would show L5 BA in cell H3 and in cell I3 it would show L5 BB.

If somebody could please help me to automate this, would really appreciate it. I thought I'd start off with the L4 Sheet and then should be able to apply same method to the other sheets.

Thanks in advance.