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

Item	Serial Number	Cost
Touring	YA17B025486	2199
Touring 2	YA17B025489	729
Gravel	YA17B025485	839
Gravel 2	YA17B025480	959
Gravel 3	YA17B025475	699

<colgroup><col><col><col></colgroup><tbody>
</tbody>

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

Item	Serial Number	Selling Price
Habit	CM17C015299	2600
Trail 1	CM17C015297	600
Trail 2	CM17C015298	500
Trail 3	CM17C015294	440
Trail 4	CM17C015292	1299

<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>
</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.