Copy And Add New Value To Second Row Automatically

I make hundreds of ads on a daily basis, and to automate the process if possible.

I have attached an example where I'm trying to make the following:

I have an ad and a link:

A1= Nice cars "London"
B2= www.com/"111"

I have a list of hundreds of cities (as the example above "London") and their page number ( as the example above "111"), and I want to be able to paste the cities&page number (in different rows) in a second sheet. Where the value of "city" and the "page number" would be placed in the ad and the pagelink in a new row in the first sheet.

In the Excel file that I have attached you can see in sheet 1&2 "exemple - 1A/1B" as a simple ad and pagelink, in sheet 3&4 you can see "example - 2A/2B" an example of how the output should look like.

example.xlsx