List multiple values from multiple sheets

[kang23]

I have 7 sheets. On each sheet the user can select an item from a list and write a description in the column next to it. The item can be selected multiple times on the same sheet with a different description written in the column next to it. I need a summary page where it lists the entered description for every item on for every each sheet.

A good example is given on this website:

https://www.get-digital-help.com/2011/07/17/vlookup-across-multiple-sheets-in-excel/

I've used the code from the website, it works, however there is a bug. If the user enters a new value on sheet 1, it'll override the first value in the summary table from sheet 2 rather than add a new value to the bottom of the list. For the example given on the website, if B4 "eraser" is changed to "pen" the new output would be
[TABLE="width: 100"]
<tbody>[TR]
[TD]1.5[/TD]
[/TR]
[TR]
[TD]2[/TD]
[/TR]
[TR]
[TD]1.7[/TD]
[/TR]
[TR]
[TD]2.7[/TD]
[/TR]
</tbody>[/TABLE]

rather than adding another value underneath.
[TABLE="width: 100"]
<tbody>[TR]
[TD]1.5[/TD]
[/TR]
[TR]
[TD]2[/TD]
[/TR]
[TR]
[TD]1.7[/TD]
[/TR]
[TR]
[TD]2.5[/TD]
[/TR]
[TR]
[TD]2.7[/TD]
[/TR]
</tbody>[/TABLE]



As the end users cannot code I'm trying to avoid VBA
Anyone?