if I use the macro recorder it just pastes from the clipboard and if the data isn't in the clipboard it doesn't work anymore. any suggestion how to overcome this?

I’ll be more specific I think the question is a bit vague.

every time I create a new workbook [I'm using VBA to do this]
I need to add the tile rows and some columns that have data.

so every new workbook I create needs to have this. 

how should I accomplish this?