|It appears that you are aware that if the Sheet name can't be found, the code will produce a "Subscript out of range" error.|
So, even though you said that you checked the spelling, it seems from where I'm sitting that the Sheet name on the tab doesn't match the Sheet name used in the code. Maybe there's a leading or trailing space or maybe something else is going on.
Try this, which seemed to work for me:
1 - Highlight Summary_Receipt_Fees in your code and press Ctrl-c to copy it.
2 - Right-click the Sheet tab that's causing the problem, choose Rename
3 - Press Ctrl-v to paste the string from the code.
Now the strings should match exactly and the VBA problem should be solved.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.