Can data from a Custom Field data be used by a shortcode on a per page/post basis?

Not sure I understand your specifics, add details if I am off. I assume:

  1. Your shortcode inside post’s content.
  2. You have custom field in that post with value you want.

In this case declare in your shortcode function global $post; and use $post->ID to retrieve custom field.