Excel 2007 : Concatenate

Hi,
I want to write a statement through concatenate function which look like this "The country america contributes 10.83 %in total revenue of the company followed by canada(10.61), brazil(10.4), uk(10.18), japan(9.96), india(9.75), sri lanka(9.53), nepal(9.31), holland(9.1), india(5.01), ....... etc." However it may happen sometime that number of country is more than whats in example or less in example. I want excel to automatically write the required statement correctly. Alongwith it is it possible to come out with result as given in attached excel with all calculation done automativcally like total revenue calculation or percentage caluclation upto two decimal place.
Please help.