Need help with selecting specific worksheets and copy data based on user input.

Rohan1340 

Why no Tables or at least named Ranges.  Without that, how do you know where to find data?

Do you absolutely need a hard copy of the filtered records or would a formula do?

Power Query is pretty good at appending and filtering Tables though setting up the filters would probably require M to set up the filters from the master sheet.

Otherwise, provided you are using 365, it is possible to combine references to the tables within a single array by using Thunks.  You could build a list of table names or numbers and return them as an appended list before filtering to meet you Date and ID criteria.