Link dynamic database to new workbook in excel -

i have database of data in excel want copy , paste (link) new sheet can manipulate data more readable form. however, database not have set number of cells , updates regularly (the reason why needs linked). database changes size on daily basis either shrinking or expanding. there way link database though need dynamic range?

i have similar situation 1 of reports don't want mess live data. create link going new sheet , typing =iferror(c:\user\database.xlsx\sheet1!a1," ") , fill across way , down way. iferror checks data , if there no data inserts space. how can overcome dynamic columns , issues. new spreadsheet linked raw data set , can manipulate needed.