Summing multiple worksheets

Let's say I have 4 worksheets with sales numbers, and the sales numbers on each worksheet are located in the range B3:B26. The worksheets are name Worksheet 1, Worksheet 2, and so on. Here's my question.... how can I create a formula on a fifth Summary page that will collect the sales data from the range in the four worksheets and spit it out on the Summary worksheet?


Thanks for any help

BRUCE... YOU'VE MADE MY DAY!!!!!!!!!!

THANK YOU SO MUCH!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


Wes
Louisville, Kentucky