Creating Pivot Table from Worksheet with slicers

[WxShady13]

I am copying employee's training worksheets into a single worksheet. From this single worksheet I need to build a Pivot Table so the managers can easily see who has had the training and who has not. I have experimented with VBA code, however it does not pull the data from the Summary worksheet into the Pivot Table worksheet like I had hoped. Once an employee has completed all training and the dates are greater than Today() they get a status of Fully Qualified. On the Pivot Table I need it to only list employees who are Fully Qualified for the job chosen via the slicer. How can I accomplish this?