Hello, 

If your company uses Office 365 and has MS Teams. Your IT team could probably create a Dataverse environment for you. The Dataverse is a low code relational database on the cloud. Using power apps, you could have a front end to have users edit and add new entries to the list (much better for end users than Excel forms)

With Power Query, you could pull the information through the direct SQL connection or through an API auto generated by the Dataverse in real time. 

My team has found this to be a great solution. 

Hope this helps. 

Matt

Hi Matt,

Thanks for your reply.

It will be used by various clients; some have 365 and some don't, unfortunately.

I think I've figured it out after studying the video I mentioned above, and downloading the sample file, using the row index to look up corresponding data.

I must say I've learned a lot through this!

Thanks again!