Looping through multiple worksheets to remove duplicates

I have an excel file that has 50 tabs of data. I need all of the duplicates within EACH of the tabs to be deleted. I used the following code, however it only removed the duplicates on the first tab. Is there a way to create a loop to go through each of the 50 tabs?

Range("A1:Z21000").RemoveDuplicates Columns:=Array(1, 2, 5, 7, 20, 25), _
Header:=xlYes

Thanks!

This is close. This macro has to reside in the workbook in order for it to work. The data I am getting is from another system and is an export so will always be a different workbook. For that reason I have all of my macros in a general Excel file. They all seem to work, but this one does not. Could it be associated to the "thisworkbook.worksheets" line?

I apologize in advance for the ignorance on my part as I am fairly new to macros.

Thanks!

Yep! I just figured it out, too!

Thank you so much for your help!!

I will mark this solved!