Excel worksheet loop using Macro

Hi All - I'm having trouble with something I thought would be relatively easy and unable to get through it. I basically would like to "Read Excel" in a loop by using a macro to loop through however many sheets are in this file as they can change from month to month. The data structure is the same on each tab but each contain a different element.   If possible would also like to create an attribute using the tab name so I can track where the data came from. Any help would be appreciated. Thanks