Here is a not so complicated way to gather data from diferent tables and put it into a single one. All we need is to mix a QUERY function with several IMPORTANGE functions.