advanced filter

hi.. i am using advance filter to take cell info to another sheet, i call ,over view sheet, from my main sheet, however can this also be used to collect cell info from multi-able sheets back to my new over view sheet,

or is there a better way

cheers

Bill