Hello All,

I am not even sure if this is possible or if this would be better suited on a SharePoint forum, but here's my problem.

I have an excel workbook, let's call it Scores.xlsx that is uploaded to a library in SharePoint. The content of this workbook is as follows:
Sheet 1:
Column A
Mike
Bob
Peter
Mary
Joe

Column B
94
92
90
99
85

Sheet 2:
Column A
ID#
111111
123123
124452
124512
151523
124353

I also have another workbook, let's call it Item.xlsx that is uploaded to another SharePoint Library. Both SharePoint Libraries are under the same SharePoint site. (i.e. Both libraries show up when you select Site Contents from the main SharePoint page). The content of this workbook is as follows:
Sheet 1:
Column A
Steak
Chicken
Corn
Watermelon
Salad
Soda

What I want to do now, is to create a third excel workbook and upload it ANOTHER library in SharePoint. This third workbook needs to pull in all of the worksheets from Scores.xlsx and Item.xlsx. So when I open this third workbook, let's call it Data.xlsx, the workbook has Sheet 1, Sheet 2, Sheet 1(1) and all of the data in these workbooks.

Is this even possible and if not, can anyone at least point me in the right direction?