Hi,
I've been trying to make a macro to create a summary sheet for a workbook I
have. I need it to run on definable sheets within the workbook, and also just
to pick out specific information along with headers. I need it also to
highlight when text is duplicated in a column range!

Does anyone have a starting point for me?

Cheers