I am new for spread sheet.
As external link doesnt work i have to download file daily in local folder with name as xyz_(date) .
i need an cell value of 50 cell from 5 files each in my sheet but it consume too much time and confusing too even after open file in libre office or renaming that file to save time.
so i am thinking to put date in seperate cell and combining that with link to get cell data i have link like =‘file:///xyz_(date)’#$xyz_date.A1 so that when i change date. the value of that 50 cells changes according to that date
please guide me to process needed
ps i had used above link to each cell separetly for all 5 files as opening whole file doesnt work well. tried navigator but it create new sheet with name similar files name again i needed to rename each sheet to calculate in final sheet if i make mistake renaming that sheet whole data will be false
thankyou for help