Search multiple sheets for criteria and paste all matched rows in new sheet

Multi-sheet workbook. Need macro to prompt user for criteria that will be found in column A (Franchise Number) on all sheets, copy the rows where that criteria is met and paste into new sheet.

See dummy example file attached. The same file only has two sheets with a Results sheets.