Transferring data from page to page

Hi all,

I am having an issue that I cannot solve for the life of me, heck I dont even know if its possible.

Basically as part of my job, managers are supposed to complete a daily log of information for their staff, and this is all accumulated on one work book. Ie/ 1st, 2nd, 3rd ect, each page has the same information that is required to be inputted ie/ mileage, start time, comments ect.

We're having a lot of issues with managers inputting and moving formulas, which is messing the entire process up.

Is there any way, on this work book, I can lock each day, and just have one summary page at the end, where for example there is a drop-down menu of all the drivers names, then another drop down of the date I wish to input data for, then a box below where they can input data, then this data is automatically transferred onto the selected day in the workbook, and then can click that day to see all of the inputted data?

I'd EXTREMELY appreciate it if anyone could help, or offer advice?

Thank you very much

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

You will have to first create name manger sheetlist for extracting how many sheets are in workbook. Follow below step.

Create a name manager naming SheetList and paste =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1))," ") formula in referes to section.

In Sheet 32

M1

Formula:

=TRIM(INDEX(SheetList,ROW()))

Drag down this will extract all the sheet name which in workbook.

Create your first drop down.

Create another name manager naming DateDropDown and put =OFFSET(Sheet32!$M$1,,,COUNTIF(Sheet32!$M:$M,"?*")) in refers to section.

On cell B3 press Alt->V>V->Allow->List->>source press F3 select DateDropDown name then ok. You first Drop down has now created.

For second Drop down put below formula in sheet 32

O1

Formula:

=INDEX(INDIRECT("'"&$B$3&"'!A:A"),ROW())

Drag down. Create namemanger DriverDropDown put =OFFSET(Sheet32!$O$1,,,COUNTIF(Sheet32!$O:$O,"?*")) formula in refers to section.

On cell B3 press Alt->V>V->Allow->List->>source press F3 select DriverDropDown name then ok. You Second Drop down has now created.

Sheet 32

B7

Formula:

=INDEX(INDIRECT("'"&$B$3&"'!A1:S100"),MATCH($B$5,INDIRECT("'"&$B$3&"'!A1:A100"),0),MATCH($A7,INDIRECT("'"&$B$3&"'!A1:S1"),0))

Drag down.

Check the attached file.

Last save the file in xlsm format only.