Thank you! I figured out the formula yesterday, but was completely unaware of the shortcuts. Now, just one more piece. Can I use a formula to actually name the sheet. For example, the course I am giving detailed data about would have a name such as RES 195. The name RES 195 would be located in a particular cell, such as B2. Can I use the contents of B2 to actually name the sheet. I don't want to just copy and paste b/c these change monthly, thus the sheet names change monthly. So can I use a formula in giving a worksheet name?

I will investigate pivot tables further. I am inexperienced with them, but will see if they would better serve our purposes. Thanks, again.