sshes wrote:
Hello,

I need help assessing a problem, and whether I will be able to achieve
the outcome I need without manually copying the data. I don't have
experience with VBA, so I don't want to attempt an automated solution
I cannot achieve immediately. For now, it would be more time
efficient to manually compile the data, but I'd like to know where to
target my efforts for additional future training.

I want to create a single tab (A) that lists values from a sequential
set of tabs (B to Z) all in the same worksheet. Each B-Z tab
corresponds to a physical warehouse, so I have a list of these on tab
A.

Each tab contains multiple rows of similar data. At the bottom of each
tab is summary data, such as Total facility rent, and Total
Facilities, and Percentage of facilities in use. Unfortunately, the
number of rows on each tab are not the same, but the same total
headings do appear on each tab. Some tabs have 10 rows, others have
100. Therefore, the headings do not appear in the same location on
each tab. I'm looking to grab specific values next to the total
heading(s) and populate the corresponding row on Tab A.

Tabs B-Z were exported reports from another program, put into excel.

Should I do a Vlookup on each tab, to pull the value next to the
desired heading to a reliable location on each tab, such as cell A1,
then use some method to look at A1 on every tab?

I'd like to know if a solution will require VBA or if a formula can
find the text heading on each tab and plug the number next to the
heading on the summary Tab A.

Thanks in advance for your suggestions.

Depending on how the data is laid out, you might be able to use dynamic
ranges to accomplish this