Summary tab pulling data from multiple spreadsheets

[doreanna]

I am trying to make sure I am using the most efficient way possible to roll up issues from multiple files into a single issue summary log.

• Multiple spreadsheets/excel files (new ones will be added on a regular basis),

• Files will be saved with the same file name with a different 6 digit number at the end.

• All will have an “Issues” tab that may have several issues on it (only 1 issue on a row with multiple columns, but number of issues will vary).

• All “Issues” tabs have the same columns

• There is a unique identifier for each issue that will not be the same as any issue on any other spreadsheet
• All Files will be saved under the same folder in Sharepoint.

What would be the best way to bring all of the issues from all of the sheets into one tab on a issue summary spreadsheet.
If it will be easier to have it user triggered, I could have a button with a macro assigned to it that I could require someone to press every time they need it refreshed.
Below is an example of the first two columns from one of the issue tabs:



<table border="0" cellpadding="0" cellspacing="0" width="342"><colgroup><col style="mso-width-source:userset;mso-width-alt:2889;width:59pt" width="79"> <col style="mso-width-source:userset;mso-width-alt:9618;mso-outline-parent: collapsed;width:197pt" width="263"> </colgroup><tbody><tr style="height:38.25pt" height="51"> <td class="xl126" style="height:38.25pt;width:59pt" height="51" width="79">Issue #</td> <td class="xl124" style="border-left:none;width:197pt" width="263">Issue Title</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl127" style="height:12.75pt;border-top:none" height="17">I-NN8980-1
</td> <td class="xl125" style="border-top:none;border-left:none;width:197pt" width="263">test</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl127" style="height:12.75pt;border-top:none" height="17">I-NN8980-2</td> <td class="xl125" style="border-top:none;border-left:none;width:197pt" width="263">test</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl127" style="height:12.75pt;border-top:none" height="17">I-NN8980-3</td> <td class="xl125" style="border-top:none;border-left:none;width:197pt" width="263">test</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl127" style="height:12.75pt;border-top:none" height="17">I-NN8980-4</td> <td class="xl125" style="border-top:none;border-left:none;width:197pt" width="263">test</td> </tr> </tbody></table>

 

[doreanna]

.