Complex Workflow Tool - Need help problem solving!!!

Hello All - Hopefully someone can help me brainstorm through this problem I have... and hopefully I can explain my issue well enough to be understood!!

So, currently, I have 5 workflows (on different sheets) where items come in and sit in queues until processed. Each queue is the amount of days the item has aged. For example, the day the item comes in, it is in Queue 1. If it is not processed, it will move to Queue 2 the next day and so on. I need to get each item processed prior to day 30.

I also have a table on each sheet that displays working hours, agents assigned, and general processing time in minutes. Basically, I can have 3 employees working 7 hours and processing 2 items an hour and that would equal 3 * 7 * 2 = 42 items for that day. I obviously work the latest queues first...First-In-First-Out method.

On each workflow sheet, I have the volume of items in every queue, and two weeks worth of dates. I have written a formula that basically takes the amount of work I can do and removes it from the top queue, or queues if there is less work than can be done in the top queue, and moves this along the two week period, consistantly moving all items up one queue as they age, and removing the max amount I can process.

It works great being that it is on several different sheets. What I would like to do is twofold: 1. I want to combine all of these sheets into one workflow and 2. I want the program to suggest which queues agents should work based on the volumes in each queue.

I am not sure that makes sense, so if you guys need to see the sheet, I can upload it. Thanks for ANY suggestions!!

please upload the sheet........


Regards
CA Mahaveer Somani