Same cell, different sheet

Looking to reference a specific cell in all of the worksheets and display the results in separate cells on one summary sheet ...?

Enter the "sheet name" in a cell & use the fill handle to drag across all sheet names (however they are named - so long as you have the tab names in a list of cells).
Assuming these are in A1:A30, then in B1, enter:
=INDIRECT("'"&A1&"'!E10"), assuming E10 is the repeating cell in each sheet, and fill this across. (That's an apostrophe inside the quotes.)

Sweet Outlook tool - FREE

Have you ever wondered who your #1 contact is according to number of emails sent and received across all your folders, including inbox and archive. Well, with Xobni, you can. Xobni - inbox spelled backwards - is a super add-on for MS Outlook that takes your email management and analytics to another level. Not only does it provide statistics on every contact by email (e.g., frequency of emails against time of day), but it also integrates with Facebook and LinkedIn to give you instant insight into your contacts' profiles. You can also see a comprehensive list of your contacts' network, all recent conversations and files exchanged - and there is more ... this is a good app.

Outlook email to calendar tip

Have you ever received an email with the date and time of an event and wished it would have arrived as a calendar item? Well, one of my favorite tips with Outlook is the easy drag and drop feature turning an email message into a calendar invite. There is a simple screen shot of that here. Enjoy! Any other Outlook productivity tips?

"With the past, I have nothing to do; nor with the future. I live now." Emerson

I had the opportunity the other day to read a little of the new book Power of Less. The main messages from the book are around learning to set clear limitations; choosing the essential to maximize time and energy. Personally, I really liked the simple concepts as I can immediately look to apply them in my own life.

Therein I noted several pragmatic, applicable to-dos that are worth sharing:
- Set aside time just for batch tasks (ideally later in the day) -- batch tasks are phone calls, email maintenance, in-box processing, visiting websites, etc. Think of batch tasks being anything life "maintenance" related
- First thing in the morning, write down your three Most Important Tasks (MITs)
- Focus solely on those tasks; do not multi-task those items
- At your designated batch time, process your in-box to empty; do not use your in-box as a to-do list
- Only check your email 2-3 times a day; once in the morning, during lunch and then in the afternoon; turn off any desktop email notifications
- Stick to 3-7 sentence emails max
- Learn to say "no"
- Create a "To be Filed Folder" within your in-box
- When going through your email, process quickly, and either delete, file away, or respond

Do you have any general or otherwise productivity tips to share?