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

1.5

2

1.7

2.7

<tbody>
</tbody>

rather than adding another value underneath.

1.5

2

1.7

2.5

2.7

<tbody>
</tbody>

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