Pivot Table Not Capturing All Of The Data

Every week I receive a new M.I. which I insert into the tab names "Brookstreet M.I", and run the macro below. When running the macro with this weeks data the pivot table appeared to miss out a lot of the data.

I think I may have to adjust my recorded PT macro to capture all data from the M.I. I have included the entire macro below. Can someone please offer some advice?

Thank You

Harry

Please Login or Register  to view this content.