Is there a way for my code to pull from different sheets??

This code is updating a summary sheet but now I need to tweak it a little to grab just a portion from another sheet but do the exact same thing? How do I make it look at sheet summary 2 ?? I'm not very good at vba and would really appreciate any ideas -- thank you!!!

Please Login or Register  to view this content.