Excel VBA - Extracting Row of Data from Multiple Sheets with Unique Value in Column A

[Nated93]

Hi All,

I have a workbook with multiple sheets of data. Sheet names are listed on the "Master Input" sheet and range name is "Bottom_Up_Sheets".

I would like to extract each rows data if the value in column A = "`"

Row range is from A:BZ

Thanks in advance,
Nathan

 

[Warship]

How should collected data be arranged - where should it be put?
Are there multiple rows containing the "`" per sheet to collect?