Help with dynamically pulling data from other workbooks

Dolenhil

New Member
Joined
Mar 4, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Good evening and thank you in advance for your time and support.

I am creating a daily report that has a date-specific name for example.

01-03-2021 Daily Report
02-03-2021 Daily Report
03-03-2021 Daily Report
04-03-2021 Daily Report

And they are all saved in the same folder.

The idea is that each report pulls data from the same 12 cells of the same column of the previous day's reports, so =today()-1 should then be the variable.
I tried "& or concatenate to break down and put together the address of the other workbooks but nothing is working up to now.
Just to give some heads up I don't want to use indirect as that would mean that the workbooks should be open which I don't want.

Any ideas?
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Forum statistics

Threads
1,148,159
Messages
5,745,118
Members
423,925
Latest member
globaltlg

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top