Copy Data from different workbook to master report workbook

[spider_min]

Hello There,

I have a master report and need to input the information from different workbook by FED#1, #2,..throught #10.
Each Fed# (1-10) have its own workbook which include all information.

How to code to generate the data from the master report from one click by:
1. selecting the file (for each County)
2. sorting the data by FED#
3. copying and paste only FED#1 to the Master Report FED#1 tab, FED#2 to Master Report Fed#2 and so forth.


Hope this make sense. Please see the attached files.

Thank you