Two approaches:
1) Pull all the workbooks into a PowerQuery, create a table with the relevant information you will want to extract and lookup that table from your Subscriptions worksheet
2) Use VBA to open the file and extract the relevant information