It does sound complicated and I would prefer to avoid a lot of potentially wasted effort. I can think of (at least) two ways of doing this but I would like to see the workbook layout for myself.
I will e-mail you. If the workbook is not commercially sensitive, reply attaching a copy of the file. Then I'll see what I can do.