Filter multiple worksheets based on data input in a master works

Closed
Report
Posts
3
Registration date
Monday April 11, 2016
Status
Member
Last seen
May 17, 2016
-
Hi,

I need some help with creating a VBA. I have a workbook that contains 6 worksheets. The first worksheet is a summary of the data listed in the 5 other worksheet by month. Worksheet 1-5 has a column that contains data by month and the summary worksheet has a cell (B1) that will allow me to input the numerical month I would like to filter worksheet 1-5 by. Can someone help me with creating a VBA that will allow me to filter data in worksheet 2-6 on Column E based on the numerical month I input the cell B1 of the summary tab? I added a link to the sample workbook I created.

https://www.dropbox.com/s/wtlqsmw0yc03l0u/sample%20workbook%20Filter.xlsx?dl=0

Thanks