Does anyone know how I can have a cell within a worksheet show the same info that's on the tab for that pageautomatically?
Not exactly sure what you're asking here..... you want cells to display the name of tabs?
infomation in other tabs? ... for this lets say you're entering names into colum "A" .... starting with A1 and you would like those names to also display on Sheet 3 starting at B5....
On sheet 3 simple, B5, simple enter "=" then go to sheet 1, click A1, and enter.... not A1 from sheet 1 will display in B5 of sheet 3.
... lets say your first sheet is named MYFIRSTSHEET , and you want that info in MYFIRSTSHEET A1 to display on MYTHIRDSHEET starting at B5..... go to B5, enter "=MYFIRSTSHEET!A1" and that will also work **** Note: you need the sheet name EXACTLY correct ****
Once it is entered then just grab the little black box and you can drag this function left/right/up/down to populate other cells from that function (assuming you're going the same way as the sheet/cells you're getting your initial info from)