Transfer specific data from several sheets to one summary sheet

[icklemiller]

Hi, this is my first post- looking for a bit of help. I'm ok with certain formulas/functions, but a total macro virgin.

What i'm essentially trying to do is...

I have a production workbook, with two summary pages that feed from various bits of information on all my other sheets (one for each day in the month).

I'm trying to create a third summary sheet that will show me a list of what stage our various jobs are at in the production cycle- e.g. if the job (entered in one row, over various colums) has a "S" in the first column, it's at "setting out" stage and should automatically appear under the "setting out" jobs heading on the new summary sheet. When the "S" is changed to a "M" it should then jump out from under this heading and into the next heading, etc, etc, 'till the job is complete.

There will be 6 different stages (s,m,j,b,p,d) and each stage should have an area of it's own in the new sheet, where all of the relevant jobs fall under- the information will be pulled from potentially 31 different other sheets (one for each day of the week)

Hope this description makes sense- any ideas?

 

[sweater_vests_rock]

so the code is working now? what underscores?

 

[icklemiller]

I think i copied the underscores from your signature....duh!!!

I've made a new post entitled "help to tweak a macro" if you fancy taking a look at that? Cheeky, i know, but i thought...no harm in asking!!