I have 20 worksheets that are all laid out the same. I want to look up a value between these 20 sheets and return the value in cell D1. I was initially trying to return the name of the sheet this look up value was found on, but that doesn't look like it can be done, so I made a formula in cell D1 of every sheet that has the value of that sheet. So, cell D1 in sheet 1 has "sheet 1" in it. Cell D1 in sheet 2 has "sheet 2". I have a front sheet that looks up a value in all sheets (A:D), and I want to return only cell D1. This is too simple for me to figure out, hehe.