Formula for Retrieving Previous Days Information

Hello,

I have information in tabs 1, 2, and 3. The spreadsheets contain information for every day of the month. I am looking to make a spreadsheet in tab 4 that contains certain information for the previous day. Tabs 1,2, and 3 get information entered to them on a daily basis. The number that gets entered is production information from the previous day and contains lots of information in which I do not need all of that. What I am looking for is a few cells from each tab 1,2, and 3 from the previous day. So for example if today 12/10/12 I want to be able to go into tab 4 and have it display information from 12/9/12 if that makes any sense, but only a from few specific cells.

Thank you for your help!

Thanks this will work. Another question though.....say it's a Monday morning and I want information for Friday. I know you can go in and change the formula to subtract more days but is there any way for it to detect that there was nothing entered in on Sunday and automatically jump to the most recent day that does have information in it?

Thanks

Thanks this works great!