Need help with complicated use of count background color of Cell

I have 3 spreadsheets within a workbook:

CountSummary is sheet1
Men is sheet2
Women is sheet3

CountSummary counts the data based on the color of the background colors in
the Men and Women spreadsheets

Men consists of data for John and Rob. The information related to each are
separated by a black filled cell which I use to separate their data.

Women consists of Jane and Mary formatted the same as €œmen€�

In the €œmen€� worksheet €¦.If the current month is AUG find previous month
(i.e. JUL) in row 3 in columns F thru Q. [note the months are text in row3
and formatted as Jan Feb Mar Apr May etc.]. [The real €œprevious month€� date
formula is located in Cell A3 and is formatted €œmmm€�] Then in column A find
€œJohn€� and count all cells in the previous month with bright green background
and stop counting or looking for green when you hit the first black
background in that same column, then in COUNTSUMMARY sheet look for the row
labeled €œJohn€� in column A and place the total count in COUNTSUMMARY in
column H in the same row as €œJohn€� and change background of that cell to
bright green. If the count is 0 then 0 IS NOT displayed and the background
does not change color.

Then follow that same procedure but now count red cells and follow same
procedures as above but put in column P.

Then I need to do the same thing for €œRob€�.

Then I need to go to the €œWomen€� spreadsheet and do the exact same thing for
€œJane€� and €œMary€� and have the count information placed in the correct cell
in SHEET1.

Any ideas on how to do this without having long winded VBA code? Thanks in
advance. I hope I made sense.