Here is the code: 
Please Login or Register  to view this content.

The code works great and searches the entire sheet and returns the Total value. Instead now i want it to search all sheets after Sheet 2, then copy each value it finds to Sheet1 so that way it can be totaled up from there.

So basically the modifications to the above list are: search all sheets after Sheet2 for rngfnd2, copy all values it finds into sheet 1, starting in Row 1 of Column Y and continuing down.