VBA to Create new workbook with templated tables but reading from dynamic range

[Melimob]

HI

Can anyone recommended a tutorial which shows me how to:

1. From a tab which will contain Country name and variable client data
2. apply info across multiple sheets in preset areas
3. lists will be dynamic
4. Save as CountryName_Move_Doc_Date

Or something along the lines of having a template but adding in variable data from a dynamic range and saving with new name. As the file will be saved by different people it will have to ask where they want to save.

Many thanks
Melissa