One File, many data (AB!, AC!, AD!, AE!) sheets, one report sheet.
The Data sheets have numerical lists in column E (column F is the "name"
field)
Report Sheet has one modifiable cell entry to populate the fields within
itself.

How do i manipulate a formula (to look at a specific sheet) by adding text
to another cell?

ie: Modifiable Cell: (let's say this cell is Report!B2) "AE034"
Protected Formula: =VLOOKUP(RIGHT(B2,3),LEFT(B2,2)&"!"&"E:F",2,FALSE)
(:doesn't work:)
i want to tell the protected cell to become =AE!F34 and naturally display
the "name" within the data sheet AE.

Questions for excel are generally more difficult to ask than the actual
formulae!!!
:)