✔ 最佳答案
you can use import external data function, Data, import external data, new web query, type the website address, then import. (the format is changed as excel format).
go the range of website, right click, then select data range properties, then you can select the time of refresh the data, say one minutes. so the data will be refresh automatically within a minutes.