Filter Multiple Sheets for Same Criteria that is entered in a dialogue box

Hi,
Thanks in advance for your help. I have a workbook with multiple sheets (we'll call them A, B, C, and D). I would like to be able to create a shortcut/macro to filter A, B, C, and D for the same criteria that is located in column A for every sheet. I would also like a dialogue box to appear when I click on a keyboard shortcut where I can enter that criteria. Also, I'm not sure if this makes a difference or not but I run this set of reports every week so I would like for the macro to be available to every spreadsheet. I'm assuming if it's saved to my personal macros that this shouldn't be an issue. I really appreciate the help!

Kind regards,
Wendy

If the data structure is same for all sheets then this will help you:

Please Login or Register  to view this content.

Thank you so much! I forgot to mention that there are other sheets outside of A, B, C, and D, that would not need to be filtered.

Also, the column to be filtered will be in Column A only for all the sheets. Does this make a difference?

When I tried the above I received the following error:

Run-time error '1004':
AutoFilter method of Range class failed

Thanks!