Hi, Lana.

Yes, if you have multiple tabs on a Google Sheet, each tab will have its unique URL,

and in our plugin, you can make one table from each tab.

-

You can see more details on connecting our tables to Google Sheets here.

If you need to use a Google Sheet with formulas, please check this guide from our Documentation.

I hope that helps.

Let me know if i perhaps misunderstood the use-case.

And i just wanted to point out that you can try wpDataTables before purchasing

 on our sandbox Demo sites ( you can find links for the main plugin Demo,  

as well as add-on Demos, in my signature),

and there is a 15-day money-back guarantee period, 

so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

Let me know if you have any additional questions.