Extracting and combining data from specific sheet from multiple workbooks

I have searched and found similar answers, but haven't been able to get a code that works for my situation. I have multiple workbooks all containing several sheets, but only need certain data from one specific sheet in every workbook compiled into one sheet. All of the sheets containing the data are named the same (Unit Availability) as well as the cell location of the data.

I have attached a sample workbook and sample output so you can see what I am trying to accomplish.

Thank you in advance for your help!

TTT for the morning crowd.

Not sure what you're trying to accomplish, but if you select your out sheet1 with both workbooks open, this should pull the data I think you're after.

Please Login or Register  to view this content.

Kind of what I am looking for, but not exactly. I want to have all the files in one folder when I go to run whatever macro is created, so I don't have to enter all the workbooks names separately.

I think this is the closest I have come to what I am looking for: http://stackoverflow.com/questions/1...gle-sheeted-wo

Or this: https://sites.google.com/a/madrocket...s-to-one-sheet

Just need help customizing to my needs.