Data analysis template

Hello there,

I want to make an libre office data analysis template
And make the source outside file…
Like make button * Upload Sales*

And Link between Source data base
And the day sales

Where Sales belongs to categories…
which i can’t Recognise unless it link to source database

So we have

  1. Source data base

  2. Week sales



I- Link them

II- Auto Recalculate and analysis Template to show results.

  • Hope i can connect it automaticaly with no needs to copy and paste sales data

How to do that please?

Or shall i link data but have to copy sales manual to work sheet to get analysis?
And if so, How to do it ?