Find Formula

I have a huge workbook with 100+ sheets and am having to search through the whole thing for multiple values. I was wondering is there might be a way I could create another workbook that could find all of the rows that contain the value "1" and collate them into a single workbook? The whole workbook looks something like this:

All the information in each Sheet are in the cells that you shown? A1, A2,etc? If you put a picture or the workbook, it would be easier to find an answer.