How can I automatically duplicate the values of single column range (currently used for a data validation list for a drop down) to another excel worksheet?

I (Excel 2016, all worksheets in one single workbook) have a worksheet called "Data" which has a single column named range "categories" containing values like "tools", "furniture", "appliances", "decor", ... roughly 20 entries.

I used said range for a drop down list in a worksheet "inventory".

This works just fine.

Now, in a new worksheet say "report" I want to copy all the values in the range "categories" into new cells. So I could use those copied values neatly formatted for a report with additional data like "count", "total amount" ...

I know, I could easily just select the cells in sheet "data" and copy/paste them. But it would be nice if there is a formula which auto fills the cells at the current cell - and it would be awesome if the copied range is dynamically linked to the source range so, whenever I add a new item to the range "category" the new item would also be populated to the "copy-range".

I know, I could do that with Macros, but as we e-mail those sheets, macros are disabled. So this is NOT an option. Yes, we know about VBA certificates. Still, VBA is NOT a solution.

Is there a neat way, besides, select-copy-paste? As we have multiple validation lists, it would be nice if there is a formula for this.

thank you