Mirroring Colors of cells and info in cells to another workbook.

First off I want to say thank you for taking time in reading this.

I am having an issue where I am trying to have the colors from one workbook go to another. I am able to get the info from the cells but I need the colors that they have as well. So as an example Book1 contains cells A1 is orange and has a value in it. I need Book5 to have the same value and color that the cell has.

My end goal is to have it so when ever Book1, Book2, Book3, and Book4 is edited. Book5 will show the new values and colors of all the workbooks in one location. Instead of having to open each one one by one and copying the information out of it and putting it in Book5.

I dont know if this can even be done. If you need more informaiton before this can be done please let me know I can give you as much as you need.

Thank you very much for reading this.

The cells should only be adjusted twice. Once for the color of the cell and once for the value of the cell. So they changed the cell blue and put the value as 100. I believe that is the answer you are looking for?

Thank you again.