Data Validation - replace choices for multiple sheets of source data

Hi,

Brand new to both the forum and using macro's in general.

I am trying to create a menu sheet from various data sheets where a drop down DV list shows the name of the item chosen under the heading but populates a price when selected.

I have used the following post with great success for 1 drop down [URL="//madrocketscientist.com/jerrybeaucaires-excelassistant/data-validation/replace-choice"]

I would now like to apply this to other sheets in the same work book to create the same function from different DV lists.

All sheets are set up in an identical manner, my problem seems to be getting the macro to read more than 1 sheet.

I have tried without success adding an array of the sheet names, although my gut feeling is this is where I need to make changes.

Apologies if this is simplistic or covered elsewhere - as stated these are my baby steps into the world of excel.

now attached the file for clarity. Basically I have a macro running the result of which can be seen in cell B3 on the SUMMARY sheet. Data is pulled from Venues sheet. I would also like the same to happen when I select from the drop down in B5, pulling data from the Facilitator sheet. I hope this helps and thank you in advance

Mark