I want to write in my code a formula that will look at a cell in the previous
worksheet. For example, I have 26 worksheets in my workbook, I want cell D9
on sheet2 to look at cell C8 on sheet1. How would I write that formula?

Bumper