Linking Worksheet File
 

I am interested in keeping a 'running tab' of income (Similar to a Daily Sales Sheet), in Excel2002. How do I have the 'Daily Sales' Workbook keep track of each individual item being sold? The sale price is located in the same cell every time, however it will need to link it to different files (For different customers) and keep a total for a store report at the end of the day. Is it possible to have a formula that takes the price of each sale (Keeping in mind their in the same cell ex. b24, but named after different clients) and adds it for a daily total? Please post if need more information for my question...Thanks...