Creating a macro to filter data on multiple sheets
 

My goal is to have a macro that will filter data on 5 different sheets, based
on a value(client #)or(Client Name) that is selected from a #dropdown list or
a name dropdown list on a 6th sheet(Either Client # or Client Name could be
selected not both). Each set of data is different with only Column A in
common (Client #), Client Name is in different columns, and the client
number/name can occur any number of times on each sheet. I am looking for
the macro to filter the data on each sheet to show all occurances of the
client number/name at once so that the user can click on the tab at the
bottom and have the data already filtered to the value selected from the
dropdown list.

I was thinking two macros one activated by a "Search #" Button, and the
other activated by a "Search Name" button would work.

I am using Excel 2007
Here is some info that hopefully helps:
Sheet1 data range-A5:N7032
Sheet2 data range-A4:V1256
Sheet3 data range-A4:R162
Sheet4 data range-A7:T388
Sheet5 data range-A3:Y6070

The values being searched in Sheet6 through dropdown lists
Client # (contains letters and numbers)-B4
Client Name-B8

I tried to include as much info as possible.
This probably does not make much sense, but any help would be appreciated!
This is my first time posting a question, so sorry in advance!