How Can I Group Worksheets On A Variable Key

I am using Excel 2007 with an extension from Adapx, Inc. of Seattle for electronic data capture and input.

I am trying to automate a process of inspecting and recording inspection data that has been collected and entered manually to this point. The data currently comes in as a variable quantity of 8.5 X 11 sheets. Some reports are 1 sheet; some are 7 or more sheets. In any case, the first sheet has all the ID information with some details and details of other samples are on subsequent sheets. When done manually, they are stapled together.

When done electronically, the report comes in as a series of worksheets. I describe the code I need as an electronic “staple” of a variable quantity of worksheets in Excel.

That is to say, I need to identify a group of worksheets as a single inspection report.

In order to make the plan work, I have the following idea. This is just my starting point. I am open to any ideas you care to share.

I need to have the current worksheet look at a specific cell in the previous work sheet.

If the value matches the value of the co-responding cell in the current work sheet, then copy the values of several specific cells into the current worksheet. This will repeat until the trigger value changes. It will increment by one. When it changes, I need to look at the next work sheet. If the trigger value matches the new trigger it will again copy the values from a specific set of cells of the current 'previous' worksheet into the then current work sheet. This sequence will repeat until there are no additional worksheets to process.