create new sheet based on another sheet filter

[tommy1234]

hello
i have an excel worksheet with pivot tables.
the pivot table based on summary data.
the entire data is separate from the workbook and place on another workbook.
i want to create a new workbook that will contain filtered data - the selection is from the pivot and the data is from the another excel file which contain the entire data.
the name of the new workbook should be :
selection+date
the amount of data is big so it must be on another file.

thanks