Looking for help with Find-Copy-Paste macro

Can You Attach The sheet?

Sure. I shaded out the areas that in my real workbooks would typically contain other data and labeled the cell on each sheet where the paste is to occur.

Look at this. This should get you started! Will look at your attachment.

What are black fields for?

Anyway, there is your file.

The black fields just signify the area of my sheets that will typically contain formulas and other data, hence everything needs to be pasted off to the right of that area. I have to step out for a while but I will take a look at your macro this afternoon. Thank you very much for your help!

This will copy to the right hand side of black fields.

You can use any animal name as long as there is corresponding tab with the same name created.

I should be able to tinker with that enough to make it work perfectly. Fantastic work. Thank you so much!