Multiple Queries from the Same Data Set

load Programming Worksheets as connection only
then if you want say, Report1 make Reference from loaded connection first Query say MAIN, transform as you need and load to the sheet
if you want Report2 create next Reference from MAIN and transform it as you wish
etc... etc...
After that you can change name of reference to eg. Report One, Report Two , etc...

don't do anything with MAIN - all what you need do with References

refer.jpg

All your changes in source data will be reflected in your Reports

Edit:
Out of PowerQuery
You've hardcoded links to data from source, it doesn't make sense to me because both (or more) workbooks work if they are open. With closed source you'll get error.