Hi everyone

My work book has 13 worksheets. One for each month on which I record the monthly sales and purchases and the 13th sheet has a summary of sales such as BI, purchases , sales and EI for each month. This is broken down for 12 different items that we sell. On the summary worksheet I am entering a formula for purchases under the Jan columun as =Jan!B5, then for Feb column =Feb!B5 and so on. If I select these cells and drag it does not recongize the pattern of my formula. Is there anyhow I can fill this formula in faster without having to flip back and forth to the worksheets.

Thanks
Marvin