Comparing data across dozens of worksheets

Hello,

So we track sales on a weekly basis and I want to compare the text in column C to all previous weeks and if they match to turn them red to distinguish duplicates. I have tried conditional formatting as well as a few other things but no luck. Is this doable with a new worksheet each week or would something else be better?

Thanks.