Multiple Queries from the Same Data Set

I am new to "Get Data". I have determined I do not need a data model. I have data entry tabs and reporting tabs. Essentially, there is too much information for one 11 x 17 piece of paper. So, I am "getting data" and slicing up my data entry tab to create two separate reports I can nicely print ( Building Program and Building Occupancy ). Both query tables reference the same set of data; each have just been edited to remove particular columns. Is there any inefficiency issue to referencing the same batch of data multiple times? The query pane lists each link multiple times. Being new to query, I want to make sure there isn't a way of linking once, refreshing once, when the links are actually all to the same root worksheet.

Thanks in advance!!!

Three exclamations. An odd number feels right.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I’m holding my six-month old; I’m not at the computer. What do you mean by hardcoded? I do work with them all open.

Oh! And thanks!!!

You are welcome

If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
If you did it already - ignore it.
Thank you.

Oops. Look one message above. I asked an additional question right before I said “thanks”

I was thinkin' "Oh!" = understand

=ROUNDUP(SUMIF('path_to_the_source[Programming Worksheets.xlsx]Building Program Worksheet.'!$H$13:$H$65,'path_to_the_source[Programming ........... etc etc...

it doesn't work with closed source workbook

Right! You are looking at the "Executive Summary". I have done quite a bit of re-work since we last spoke about dynamic updates. I reorganized all my tabs, switching which workbook they lived in. I decided on one file for data entry and one for printing. The "Executive Summary" I haven't touched yet. It has way old formula references. I have learned how to name cell ranges since then too! I never did hard-code the file locations, however. I do see the file path as you are pointing out. That appeared as I moved tabs around. I am not sure why. I had to purge and re-do all the formula out of my "Programming Worksheets" file. I am just getting back to re-doing the "Programming Reports" file.

Someone found a formula way to do it ( search for my other recent post ). I still don't understand why the formula works, but I have it. With the formula, however, the bottom actually doesn't flex; there are just empty linked cells. I want to create new total rows at the bottom; the formula array would thus present an issue. Did you see my row height post? The total row flexes with the bottom of the query table, but its row height will not stay. I describe it more in its thread.

Oh! = I forgot to say thanks before I got greedy about the wonderful help Hahaha.

Oh! Even more interesting. You can refresh when inside Power Query, not inside Excel. It's a connection. That sort of makes sense.

Interesting thing happened. I liked your "connection only" idea. It took me a bit to Google how to find that setting, but I found it. I cannot refresh, however, a "connection only" query. So, the idea about clicking the master doesn't really work. I think I will probably just re-name the individual queries without the master all together.

Am I missing something?

Maybe read this:
Getting Started with Get & Transform in Excel 2016
and this
Microsoft Power Query for Excel Help