Sorting Data From Multiple Worksheets Into One Worksheet Based On the Date(s) Selected

[visceralchaos]

Hello All,

I am trying to create a workbook to help document/record the history/tasks completed on the floors of our hospital. There are roughly 226 worksheets in my workbook. Each sheet corresponds to a specific room number or area within the hospital. I have one sheet named "Room Numbers" and another named "Map". You can either select the room/area by clicking on the room number in the "Room Numbers" worksheet, or by clicking on a highlighted area of a map of the hospital. Either method will transfer you to the specific room/area.

Once there, I want staff to record the date and what was done on the floors (i.e. scrubbed, mopped, burnished, stripped, rewaxed, extracted carpets etc.).

I would like to have another worksheet available that would pull from all 226 worksheets any tasks that were completed on a specific date.

For example, I've been off work sick for a few days. I come back, and I want to know what the floor crew accomplished on the days I was off. On this new worksheet, I would enter in a specific or range of dates and it would give me the results of what had been done during that time frame.

Is this possible to do in Excel? I am extremely new to VBA and the other advance features of Excel. Any help is appreciated.

Attached is an example of the data I'm trying to record. I had to delete most of the worksheets to get the file small enough to post.

Thanks,
Nathan

[arlu1201]

Do you have a sample file showing how you want the output to show?

[visceralchaos]

Try this one.

zFLOORMAINTENANCE HISTORY DEMO--------z.xlsx