Hi - newbie so apologize in advance.
I have a workbook with 10 sheets
Each sheet has a set of data in columns G:Z
Each column has a unique header
Not all sheets have the same header columns
Each sheet column has a different total of row data i.e. Sheet 1 has 121 lines of data; Sheet 2 has 72 lines of data; Sheet 3 has 44 lines of data - these rows of data will never increase
I need to create a single view page that contains all header\columns from each individual sheet with all of the row questions which I've manually created
Next I need for my single view to show each sheet's information vertically even if the header is missing from a sheet
For example if Sheet 1 and Sheet 3 both contain the header Apples, but Apples are not on sheet 2, I need my single sheet to show in Column D the header name Apples and then rows 2:121 the data from sheet 1, rows 122:194 blanks because this set of rows belongs to sheet 2; below that I need need the next 44 rows filled with the data from sheet 3 etc. until it completes reviewing all sheets.
In the end I will have a replica of each sheet in a vertical format of inputs. I have no clue where to begin and would appreciate the assistance. TIA
I have a workbook with 10 sheets
Each sheet has a set of data in columns G:Z
Each column has a unique header
Not all sheets have the same header columns
Each sheet column has a different total of row data i.e. Sheet 1 has 121 lines of data; Sheet 2 has 72 lines of data; Sheet 3 has 44 lines of data - these rows of data will never increase
I need to create a single view page that contains all header\columns from each individual sheet with all of the row questions which I've manually created
Next I need for my single view to show each sheet's information vertically even if the header is missing from a sheet
For example if Sheet 1 and Sheet 3 both contain the header Apples, but Apples are not on sheet 2, I need my single sheet to show in Column D the header name Apples and then rows 2:121 the data from sheet 1, rows 122:194 blanks because this set of rows belongs to sheet 2; below that I need need the next 44 rows filled with the data from sheet 3 etc. until it completes reviewing all sheets.
In the end I will have a replica of each sheet in a vertical format of inputs. I have no clue where to begin and would appreciate the assistance. TIA