Get Data For Specific Date From Across Multiple Sheets

[paul_pearson]

I assume you were referring to typing in 9 aug in the userform date..i changed the date format in the code to dd/mmm/yyyy..this worked as far as I can see

Do you seeany issues with this

Thanks

Paul