more elegant way to add a new table in a new worksheet to a query|Power Query|Excel Forum|My Online Training Hub

hi 

I have created a power query file with 3 worksheets /3 tables and done a simple append to get them to load together - which is fine...I have a couple of questions..

1. Choosing to tick the box for "Add this data to the data model" - basically means it's now loaded to PowerPivot and I can work with it from there and I can also create a pivot table from all the sources - assuming they are linked together? Is that correct or am I missing something?

2 So I have my append query done for Quarters 1-3 - so when Quarter 4 comes along - I get I could just edit my append question, check the gear beside the source and add it in from there...(assuming I have loaded it to the PQ - connection only) - is there a more elegant way to do this so that if a user comes along, puts in a new worksheet with Quarter 4 data that I can get it to append automatically ? If I don't, that's OK but would like to know..

3. If data cleansing needs to be done on each of the three tables, am I better off doing it on the appended data set or on the cleaned up data set assuming it's pretty much the same cleansing to be done. If it's different I assume I'd be better off doing on each of them...

4 . I've given the tables and queries the same name - presume that's OK in this scenario. 

Thanks as always..