Macro to merge data in excel (similar to mail merge)

Program Steps

The program needs to find words in {} in Template sheet
find relevant column in Data sheet
substitute the data inside {} from the respective column and remove {}
save for all combinations below template

This is something similar to mail merge in word, but data is dynamic.

Thanks a lot in advance.