Find Formula Required And Slicer

[kme]

Here Attach Jan Feb and May Data

While Selecting Employee Name There is Division Details Automatic Came through excel formula

Slicer Needed Month Wise Sales

A new data sheet will be added every time the same month is complete.

Answer Required in Sheet "Answer"

Sample Answer Data also Given

 

[vletm]

... or all data in one sheet.
You can see almost as 'required' with Pivot-table.

 

[Peter Bartholomew]

This might provide a start if you have Excel 365

 

[kme]

Very Very Thanks .