Import data from one workbook to another

[manc]

Hi Demigods,

I do not have a specific issue at this time, more just want to gauge your advice...

I would like to have two workbooks - one called backend, one called frontend.

The backend contains rows of data.

The frontend contains the backend data imported into it.

Is it possible that if a change is made to the backend data, the frontend adjusts in real-time?

We can do a power query ok, and it will update changes after 60 seconds, but we are looking for a faster option, ideally without having to have the backend open.

Any thoughts/ideas would be greatly appreciated.


Best regards
manc