Macros to copy image

[rajaykumarca]

I have written a macro which calls a symbol based on a cell value (For example: if the value is <4 a red circle appears, if it is > 4 a green circle appears). I have 10 different worksheets which has either this red or green symbols.

Now I have a cover sheet where I need to populate these symbols in a table. I am trying to figure out if this can be done through a macro as I don't want to use conditional formatting?

Thanks in advance.