The venue name and number must be correct other wise it can't find the webpage to download.

To solve the earlier problem add this code to sheet "Data" cell V1 then copy down the column.

=IF(W1<>"",IF(ISERROR(CLEAN(TRIM((LEFT(Meetings!W1,FIND("-",Meetings!W1,1)-1))))),CLEAN(TRIM(Meetings!W1)),CLEAN(TRIM(LEFT(Me etings!W1,FIND("-",Meetings!W1,1)-1)))),"")