Copy formatting, text, formula and location of a group of cells to another workbook

I need to be able to copy all this information into a new workbook. I'm not the greatest at MACRO at all so please be kind

I need to copy formatting, text, formula and location of a group of cells to another workbook. Not a particular workbook but whatever one I am working on, and It needs it to sit in the right spot to work out everything properly. As easy as it is for me to copy and paste to the new document its not for me, its for my less computer savvy mother and it needs to be simple (thus why I am thinking a macros button) I feel I've tried everything I can find on the net and have hit a wall, anyone know how to do this? or a similar work around?

(Hopefully I've attached the example here correctly)

Thankyou

Okay i solved the issue by recording every step in macros, manually entered each formula and it done the trick. long work around but it did work!