Your question is kind of vague.
Please explain what you mean by "drag a sheet over". Also, please go into a little detail about how many sheets and what ranges are involved, and basically what you are trying to accomplish by giving a few examples. It'll be easier to help if you can fill out your question with some info about how the workbook is set up.
Like this thread? Share it with others