Advising how to complete a mail merge which uses calculated excel tables

I need help and guidance on how:- to create 50 Word reports using including data for 50 specific data sets - ‘Locations’. I also need a similar report with the Totals for all 50 Locations. I have a spreadsheet with 50 rows of data (text and numbers) – one for each Location. So far so good – I can use Mail Merge. I have some spreadsheets tables which use data unique to each Location and calculates projected Costs over a 10 year period . I want to be able to include this table – unique to each Locatin - into my Word report so that it picks up the whole table of 10+columns and 20+ rows (Cost items). I do not want to manually copy it in Location by location. I am hoping that I do not need to create 200 columns on my Locations spreadsheets and then create merge names for each field on the table. In fact I will have a couple of this type of table to merge so it would be a laborious work around. I don’t know how to do this correctly and need advice as Im sure there is a solution I use Word and Excel. I do not have the luxury of time to learn about databases - though I am happy to learn about more advanced Excel techniques. Though not essential I would also like to merge images/photos unique to each of the locations in each of the Word reports without manually copying them over.

Project ID: 24444180