I tried both of those suggestions and neither one worked for me. I think it's having a problem calling the sub if it's in a different sheet other than my itmof tab and vice versa, if the sub is in my itmof tab and I assign it to copy data macro, then it errors out a certain line in the sub...

Thanks