macro to consolidate data from worksheets within workbook based on criteria

hello

need some help from the vba gurus.

i believe the task is simple but i may be wrong.

i have over 55 worksheets (in my attached sample, i have shown only 4) district sheets that contain metrics.

in my "consolidate" sheet, based on the drop down in cell D3, i would like for the macro to only consolidate (copy/paste) the data from that particular week. cell D3 = time frame.

this, i would like the macro to only copy/paste and dump the data into the consolidate sheet for all "active" or unhidden sheets for the selected time frame. the time frame are listed in column B of each district worksheet.

please help...thx u in advance.

**i have copy/pasted manually** from one worksheet to show an example in the attached.