Why do you need a macro for this?
Is the formula changing all the time?
Do you just want to "punch" a formula through to all sheets?
Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.