Does anyone have any suggestions on how to retrieve data from web link?
As I know, Data Import External Data New Web Query, after inserting the
web link, the whole page will be loaded into Excel - temp worksheet, and then
I can retrieve the required data into Summary worksheet by locating the data
from specific cell under temp worksheet.

Does anyone know any other approach to retrieve the data from the web link
without importing into temp worksheet? For example, if I know the specific
data will be located in cell B11 under temp worksheet, can I create a
specific web link referring to this location for retrieving data without
loading the whole page into temp worksheet?

Thanks in advance for any suggestions
Eric