how to get data from several sheets on to pivot table

Hi everyone, i am looking for little bit of help i have recently created my works off duty for all the staff and would like to know how to filter by name so it shows up what days they are working for each week..each week is on a separate sheet.


Name Monday 27th Tuesday 28th Wednesday 29th Thursday 30th Friday 31st Saturday 1st Sunday 2nd

joe 0800-1600 0800-1600 0800-1600 0800-1230


each sheet represents a new week

how do i get to filter the name Joe so that it shows me his off duty for the six weeks

Please help
Dougers1

how to i add attachment of my spreadsheet so that others can see

here is my workbook hope this helps with what im trying to get across

is this a simple procedure or is it quite difficult to arrange.im hoping to be able to do this as it would make life much easier at work

this is what im looking for in the consolidation sheet i can filter by name and sheet.....now just need to work out how to do this

thank you very much. this is going to help me

this has been great help to me and has now got me thinking....if i was to and 2 rows at bottom of the off duty with numbers for each day ie: early and late where it tells me many people have on a early & late shift each day of the week. would it be possible to add code so that i could let staff ask for annual leve and if the number is low then it says No.

basically what i mean is is it possible for so that it set up a input box asking to check what day of week the want annual leave,and if number is lower than 7 then answer is no

imagine you were looking for annual leave ...the code would check how many staff are on the day (early & late)...and if numbers are below 7 then answer would come back saying no to annual leave

also can you recommend a good programming book.ive done some before but it was 10 yr ago and want to self teach myself again