I have very elementary experience with VB and I am (as you can tell) very inexperience with Excel.

Here is the sheet order in my work book: RFI Log, RFI 001, RFI 002, RFI 003 ....etc

Here is my problem: I have 60 or so sheets in my workbook. The first sheet of my work book is a reference page or "table of contents" of sorts for each "RFI Sheet" from there on out. On my reference page (the first sheet) titled "RFI Log", I am going to have a row for each individual "RFI Sheet" starting with "RFI 001", "RFI 002", "RFI 003" . . . and so on. Each "RFI Sheet (001, 002, 003 . . . )" row, on my "RFI Log" needs to display information from 4 or 5 different cells, which can be found on each corresponding RFI Sheet.

Is there a formula that will allow me to drag down on each separate column of data on my RFI Log where the same cell on the next RFI Sheet (001, 002, 003, 004 etc....) will fill in the data on my "RFI Log"?

I know this is confusing. If you have any questions please let me know. Any help is immensely appreciated.