Linking Data from Multiple Sheets

[el bosco]

Hello all.

I am working on a project in excel and, rather quickly, what I want to accomplish has surpassed my skill set. So I have two sheets (Sheets 1 and 2) within a workbook, arranging inventory items by category, and then I want to compile all of this information in an additional sheet (Sheet 3). The difficulty I am encountering is that if I make a change in either sheet 1 or 2, I need that to be reflected in sheet 3. For example, one of my columns is Price. I can link the values from one sheet just fine, so that if I change a price or add an item this is updated on sheet three but I cannot figure out how do this for 2 or more sheets while continuing to have the values translate into one column on sheet 3.

I hope this is clear, but if not I can attempt to provide more concrete examples.

Thanks so much.

 

[ajamess]

There shouldn't be any issues with linking multiple sheets. If you put up an example, screenshot, or example table with format, I can help you with this.

 

[el bosco]

Thank you for the reply!

Sheet1 looks something like this

[TABLE="width: 225"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Item
[/TD]
[TD]Serial Number[/TD]
[TD]Cost[/TD]
[/TR]
[TR]
[TD]Touring[/TD]
[TD]YA17B025486[/TD]
[TD="align: right"]2199[/TD]
[/TR]
[TR]
[TD]Touring 2
[/TD]
[TD]YA17B025489[/TD]
[TD="align: right"]729[/TD]
[/TR]
[TR]
[TD]Gravel
[/TD]
[TD]YA17B025485
[/TD]
[TD="align: right"]839[/TD]
[/TR]
[TR]
[TD]Gravel 2[/TD]
[TD]YA17B025480[/TD]
[TD="align: right"]959[/TD]
[/TR]
[TR]
[TD]Gravel 3[/TD]
[TD]YA17B025475[/TD]
[TD="align: right"]699
[/TD]
[/TR]
</tbody>[/TABLE]

And sheet2 basically the same, but all of the sheets are grouped by category so :

Habit	CM17C015299
Trail 1	CM17C015297
Trail 2	CM17C015298
Trail 3	CM17C015294
Trail 4	CM17C015292

<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:3547;width:73pt" width="97"> <col style="mso-width-source:userset;mso-width-alt:3035;width:62pt" width="83"> </colgroup><tbody>
[TD="class: xl65, width: 64"]Item[/TD]
[TD="class: xl65, width: 97"]Serial Number[/TD]
[TD="class: xl65, width: 83"]Selling Price[/TD]

[TD="align: right"]2600[/TD]

[TD="align: right"]600[/TD]

[TD="align: right"]500[/TD]

[TD="align: right"]440[/TD]

[TD="align: right"]1299[/TD]

</tbody>

What I need is to aggregate these all into Sheet3 so that all the prices, for example, show up in one column as a total list of inventory, but also so that it continuously updates. If I were to add an item into either Sheets 1 or 2, then it appears in Sheet3.

Hope that is what you need.