How to dynamically add model

I need to create many models. Each needs to run some SQL with a pattern so I can write a macro to create the statements in model by args. After that for each model I need to put below

{{ macro_for_model(this) }}

If I have many such models, is there a way to dynamically create the model so I don’t have to create them one by one with the same macro call inside?