Excel Macro - Multiple Find/Replace

We're struggling to build a Macro - need your help!!!

The attached workbook is a simplified version of the problem, which has an "Output" sheet for what I would like to output.

I have a list of locations (>1000, here is just a selection) for which I want to output text from a specified sheet (depending on =len(location) ) using a find/replace. In each sheet (named 5,6,7,8,9) there is the symbol "¬" in a string x number of times, where x is the name of the sheet. (In the real case, each sheet is a different ad text template and includes strings of ¬)

Thus for a location, eg. London of character length 6, I want to first find sheet =len(location), ie. "6", and then do a find and replace only in this sheet (ie. replacing "¬¬¬¬¬¬" with "London"), keeping the original template and outputting the text in a new worksheet. And then I want to repeat this for each location and outputting all the replaced texts on one worksheet, placing each one below the previous.

Please get back to me if I haven't made myself clear!