Copy selected cells from a range of worksheets and paste in master table

The answer to all those questions is yes.

If the master table can be cleared everytime and re filled with all new information that would be great (but maybe make the code quite slow?)
The baskets (like the master table) could also be empied and all the values from the master sheet duplicated into each one, that would also be great.

If we can include the filters to be applied to the baskets in the code that would be fantastic, the only problem here is that those might change. i.e at the moment I might want basket 1 to 'show all the entrys in that have value a greater than 5 in column A', but that might change to 'show all the entrys with values greater than 7 in column A and values less than 2 in column B'....so it might be best to leave that to be applied manually each time unless there is a way to for the code to chose its filter values from a range cells on each baskets sheet that could be changed. Something like

set column filter for (Coloumn A, Sheet "Basket !") to be greater than value in Range ("G1") of sheet("basket 1")

and then have a table on each sheet where the values can be added....

thanks again