Need to retrieve multiple excel sheets into one based on due dates

Hello,

I'm losing my mind. Please help. I have multiple sheets, each sheet contains the name of the Court Reporter with their due dates for transcripts. Sheet One is title Court Reporter just making it easier for me to click on their name and it will take me directly to their sheet.
So when a DUE DATE has approached it will highlight in RED but I also want it to be automatically be moved when it comes due to one sheet. I have 30 sheets and if 5 out of those Court Reporter's have dues then I want to be able to see it in one sheet opposed to clicking on each reporter to see what they have due. I hope this makes sense. I am attaching my WORKBOOK.

I want to be able to see what is due for each reporter on one sheet when it COMES DUE opposed to clicking on each sheet. HELP!
Is there a code for this?

Re: Need to retrieve multiple excel sheets into one based on due dates

Quote from vwankerl;599714

I have downloaded the workbooks you posted. I have a couple of questions for clarification.

1. Is there any problem using VBA to do this? I don't think there is any way to solve this without VBA.

2. You say you want to see the information on those reporters that have due notes on one sheet. Can that one sheet be the "Court Reporters" sheet?

3. Is it possible for a single reporter to have more than one due at a time?

4. What information do you want to see from the sheets that are due?

Display More

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1.) I don't think there would be problem using VBA but I don't know how to do that. I would like to use it if it's easier.
2.) I think so as long as it shows what is due for each reporter.
3.) Yes, it is possible to have multiple due dates at one time for each reporter. For example, a reporter can have different cases and all be due at the same time.
4.) I would like to see the due date for that specific reporter, case name, case number and hearing dates.

Re: Need to retrieve multiple excel sheets into one based on due dates

Quote from vwankerl;599740

I will play around with it some and see if I can give you a solution. It may take a few days though. I am currently doing something like this on a couple other workbooks I have designed for my business so I see no problems, just details to work out.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Okay, thank you so so so much! I hope that you find a simpler way. Maybe my format is just too complicated. I will keep an eye out for your response.

Re: Need to retrieve multiple excel sheets into one based on due dates

Quote from ucanad1yn;599750

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Okay, thank you so so so much! I hope that you find a simpler way. Maybe my format is just too complicated. I will keep an eye out for your response.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Hi!!
Any luck? I hope you found something easier.

Re: Need to retrieve multiple excel sheets into one based on due dates

I still need help. Please help!