Recieve Data Validation from another workbook

Hi Everyone,

I would like to make a data validation in one workbook and have multiple different workbooks picking up a data validation from that one Excel file.
This is so I can update the data validation in one file instead of changing multiple files but just under a different sheet.

Now I have done some research and found this YouTube tutorial and step by step blog but this is not working for me.

(I am unable to add the url links as this is my first post)

Is this function only available on Windows as I use a Mac and would like the same outcome to work.

If anyone can help I will be much appreciated.

Thanks,
Scott.