Creating a pivot table from multiple worksheets

[AJMC123]

Hi,

I've inherited an Excel workbook with multiple worksheets all with vastly differing data relating to different studies.

However, in each worksheet, we sometimes record the name of a person who has "referred" a patient to a study, alongside the date they were referred.

I've been asked to summarise all the referrals people have made by month. I am able to create pivot tables for each worksheet showing a count of referrals but is there a way to amalgamate the information across all the worksheets? Example workbook attached.

Thank you

[oeldere]

Try this VBA code on a copy of your file.

After that pivot table.

See the attached excel file, for the result of the code.

Please Login or Register  to view this content.